-
hi,
I have to written a stored procedure, which accepts 2 IN parameters.
Upon the complete execution of the procedure, I want to return a status.
I tried to have a OUT - formal parameter.
From the calling program, How do i get back the value that is stored in the
OUT variable.
Also I have a problem, how to execute a stored procedure, when it has OUT parameter.
I tried to exec ute with
SQL> exec my_proc('name', age, ' ')
The 2 IN parameters are Name and age,
OUT parameter is status. Initial it is null. How do I execute it;
Badrinath
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|