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 |
What do you understand by soa and what are the benefits of using this architecture?
HOW CAN YOU KNOW UPDATE STMT IS WORKED OR NOT IN PL/SQL?
What do you understand by a set of books?
wht is format triger?
where is setup of business group done?
why r u move in the cus_top only why not move another top
what is pl/sql table and pl/sql records? what is the use of that?
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????
what is flexfield qualifier?
how can develope the po variance and po summary report? with tables mandatory columns and query please?
mention the interface tables for item open interface and open transaction interface and also their respective production tables.
Is that Possible To create package without Specification , If Yes Give any Examples