in procedure how to return a value
Answers were Sorted based on User's Feedback
Answer / amit
In a procedure, we can return a value using OUT PARAMETER
or EVEN USING IN OUT PARAMETER.
For Eg:
CREATE OR REPLACE PROCEDURE add_num(a IN NUMBER, b IN OUT
NUMBER) IS
BEGIN
b:= a + b;
END add_num;
The IN OUT / OUT parameters can be modified within PLSQL
block and the updated values of this parameter can be
refered using a actual paramter once the execution of this
procedure is completed.
Is This Answer Correct ? | 8 Yes | 0 No |
In procedure we can return value using Out Parameter,
Is This Answer Correct ? | 1 Yes | 3 No |
How do you register report in oracle apps?
do i need to declare bind parameter before using in the query?
What is function?
what is the defference between credit memo and debit memo
Presently u are working in which version?
What is workflow?Explain with a example?
While running the concurrent program we will get the status, we have to change the status. How it will be done.
What will happen If I am not giveing the Suspense accout while defineing the Set of Books in GL?
we have select statement in that two exceptions that returns no value. In that which exception will raise?
We have to show a logo/image in a report? what are the steps and which format it is?whether in pdf format is applicable or not?
what type of testing u r doing?
what are the tables of auto invoice.