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 |
why r u move in the cus_top only why not move another top
hi gurus my name is ramesh i was completed orcale apps technical trainning i wnt to put 3+yrs experience is it correct r not ,if any freshers jobs are available in market pls suggest me. my mail id rameshmcaou@gmail.com and contact no is 9000342411
Can we create tables in apps schema?
How can we import the data into a database using sql * loader?
Give a brief overview on OrderManagement.
what is instead of trigger in where u will use?
What are basic steps for AIM?
types of invoices?
7 Answers BelAir Store, Convergys, Wings Biotech,
What are the benefits of using soa architecture?
please send me forms, xml pulisher questions,answers
Tell me some thing about SQL-LOADER.
what is meant by lexical parameter