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
7576 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

Explain an exception and its types?

1009

How to empty your oracle recycle bin?

980

20. Using a set operator, display the client number of all clients who have never placed an order.

2145

Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

2045

How to use subqueries in the from clause in oracle?

1043

How to create a new table in oracle?

1065

How do I uninstall oracle client from windows?

961

How to test null values?

1042

What is a nested table?

1004

What is the implicit cursor in oracle?

1036

What is an oracle wallet?

881

How to drop an index in oracle?

1019

How do I start tns listener?

988

Can we write dml statement in function in oracle?

1023

How to check the oracle tns settings?

990