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
Do you know what is applysys in oracle application database schema, what is apps?
Can we create tables in apps schema?
what are the different transaction clauses in AR?
Tell me where we find the status of order information?
What are file in oracle.
Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?
how do you describe O2C along with tables
where to define interorganization transaction charges and what are the different options?
What are the different components of soa suite?
Do you know what are user profiles in apps. Any examples you can give?
What is instead of trigger in where we will use?
CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP
Do you know where we can check the status of po?
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?