Write a simple Store procedure and pass parameter to it ?

Answers were Sorted based on User's Feedback



Write a simple Store procedure and pass parameter to it ?..

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

Write a simple Store procedure and pass parameter to it ?..

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

Write a simple Store procedure and pass parameter to it ?..

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

Post New Answer

More Oracle General Interview Questions

How to write numeric literals in oracle?

0 Answers  


How to declare a local variable?

0 Answers  


How to use "while" statements in oracle?

0 Answers  


What is different bet native dynamic sql and Dbms_Sql?

4 Answers   Thermotech,


What are a collation and state the different types of collation sensitivity?

0 Answers  


What is a trigger and what are its types?

0 Answers  


How to export data with a field delimiter?

0 Answers  


What is index in Oracle?

0 Answers   MCN Solutions,


How to find out what privileges a user currently has in oracle?

1 Answers  


How to get a list of all tables in the database?

1 Answers  


What is the difference between 10g OEM and 11g OEM?

0 Answers   MCN Solutions,


How to insert multiple rows with one insert statement in oracle?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1808)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)