Create Or Replace Procedure Test(p_Var1 In Number) As v

Write a simple Store procedure and pass parameter to it ?

Question Posted / sanjay

3 Answers
7856 Views
Keane India Ltd, I also Faced
E-Mail Answers

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to rename an existing table?

1207

How to compare dates in oracle sql?

1156

Difference between inner join vs where ?

1093

What is where clause in oracle?

1074

What is Redo Log Buffer in Oracle?

1276

How to use select statement to count the number of rows in oracle?

1092

How to view all columns in an existing table?

978

Explain the use of rows option in exp command.

1145

What is a static data dictionary in oracle?

1184

How to loop through a cursor variable?

1124

What is the relationship among database, tablespace and data file?

1034

How do we get field details of a table?

1025

What is meant by raw datatype?

1115

Write a trigger example in oracle?

1110

How to resolve the ORA-39133 error in Oracle?

1179