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
List the various types of value set.
Can you explain the difference between architecture followed in 10g & 11g?
How do you register report in oracle apps?
pls send me out bound code of supplers,site,bankiformation code pls as soon as
Do you know what are user profiles in apps. Any examples you can give?
What is count(*) from po_vendors(any table)?
In sequence i want to 11 and 15th values how we will write?
In oracle application how do you debug or trace errors?
How is choreography different from orchestration?
What is oracle soa suite and what are its different components?
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?
where to define interorganization transaction charges and what are the different options?
What are the Standard Reports and Forms in HRMS?
what are the balancing segments in AR?
How can we import the data into a database using sql * loader?
