Write a simple Store procedure and pass parameter to it ?
- 3 Answers
- 6997 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
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
how may join possible between (requisition with purchase order)
What is a cursor variable?
How to connect to a remote server?
What do you mean by merge in oracle and how can we merge two tables?
How translate command is different from replace?
How to convert characters to numbers in oracle?
What is the difference between substr and instr?
How to use attributes of the implicit cursor in oracle?
What is bulk copy or bcp in oracle?
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
What is a private synonym?
Is rowid unique in oracle?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
What language does oracle use?
