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 |
can we use anchor propery in XML reports?if yes?explain?
What is oracle soa suite?
Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?
what is the back ground program run while transferring data from OM to AR?
hi all.i am in need of some sample codes for oracle apps manufacturing interfaces.If any of u have,plz send it to me . Thank you.
In which table or database definition we can find the link of organization and operation units.
WHAT IS USE OF APPS API?
How to create a link between One dependent value set to another Dependent value set
5 Answers Indorama, ManSoft System, Syntel, TE Data,
What are do's and dont's of Interface?
i have 100 pages output. i want to print 10 records per page in Template?
AOL?
I Have report which is having field at the end of page,,, problem is when i run report data is overflowing to the next page,,i want the data to come on same page can anybody help me out????