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 |
how many sections are there in report?
After completing Report customization process.suppose we have 10 report parameter in report so, that we re-register that parameter in concurrent program?
Form development process?
How can a process be deployed in soa?
pls send me out bound code of supplers,site,bankiformation code pls as soon as
suppose you want to use a trigger in existing standard apps form and its not available in personalization neither in custom.pll. How you will address the issue ?
Can we run a package with out specification?If yes how?
In a table their 20 records.I had update 6 records???How can see and retrieve particular 6 records.i.e.,Latest updated.
10 Answers HCL, TCS,
What is set function in sql .E.g.What is difference between union and union all
Need Training & Internship with guaranteed Job in ERP - Oracle Apps Tech?
How to move the one file from one instance to another instance? And your scripts also?
What is the autonomous transaction?give me example?