Interested to Buy Any Domain ? << Click Here >> for more details...
Write a simple Store procedure and pass parameter to it ?
- 3 Answers
- 7628 Views
- Keane India Ltd, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / nikhil patel
CREATE OR REPLACE PROCEDURE test_new1(p_vari1 IN NUMBER
. ,p_vari2 IN
VARCHAR2)
AS
v_vari1 table.rollno%type;
v_vari2 table.name%type;
BEGIN
v_vari1 := p_vari1;
v_vari2 := p_vari2;
INSERT INTO table (
rollno
,name
)
VALUES (
v_vari1
,v_vari2
);
END;
/
COMMIT;
-- CALL PROCEDURE IN OTHER PL-SQL BLOCK
BEGIN
test_new1(0127,'nikhil');
END;
/
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / sanjay
Create Or Replace Procedure Test(p_Var1 In Number)
As
v_Var1 Number;
Begin
v_Var1 := p_Var1;
Dbms_Output.Put_Line(v_Var1);
Exception
When Others Then
Dbms_Output.Put_Line(Sqlerrm(Sqlcode));
End Test;
/
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / krishna
PARAMETERS <p>[(<length>)] [TYPE <type>|LIKE <obj>]
[DECIMALS <d>]
[DEFAULT <f>]
[MEMORY ID <pid>]
[LOWER CASE]
[OBLIGATORY]
[VALUE CHECK]
[AS CHECKBOX]
[RADIOBUTTON GROUP <radi>]
[NO-DISPLAY]
[MODIF ID <key>].
| Is This Answer Correct ? | 0 Yes | 6 No |
What is rich query?
Explain about your project and its relation to the current job position you are applying to?
What are temporal data types in oracle?
Hi friends can u send the oracle 9i full version download link?????????????? please reply ?
how to get the second max val for every group in a table
What is cluster Key ?
How to write numeric literals in oracle?
How to use fetch statement in a loop?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
How to find out what privileges a user currently has in oracle?
how do u know the total no of rows in a table?
Is a rollback possible to any savepoint?
Oracle General 
