Answer Posted / 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 |
Post New Answer View All Answers
Hi any one plz help me .i need 2 or 3 customized and 2 or 3 development reports on PO module..if any body having plz send me with one by one step ,i mean where u do the customization and wht are the steps u follwed when u do the customization,wht are fields u added or deleted ,How u added or these fields as per clinet requirement and wht are errors u faced .plz send it to my mail id iamvenki@gmail.com
WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?
how to print multi lay outs,muti currency,muti language in xml publisher
Do you know what are user profiles in apps. Any examples you can give?
What do you understand by soa?
testing tools?
Do you know what is applysys in oracle application database schema, what is apps?
In support project one ticket alloted which steps follows manualy tell me ?
What are the different components of soa suite?
please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in
tell my any difficult situtation you solved in your experience in your company?
Are you familiar with internet architecture of oracle apps 11i?
how can i print random rows in plsql table
How can a process be deployed in soa?
Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?