Home » SQL & PL/SQL » SQL & PL/SQL » PL/SQL out parameter and Return (oracle9i, winxp)
PL/SQL out parameter and Return [message #300089] Thu, 14 February 2008 03:46 Go to next message
Messages: 26
Registered: January 2008
Junior Member
hi guys,

1) is it possible for me to pass a value in the out parameter in a pl/sql procedure to a java variable in an java application/servlet ?

2) when i issue a return in a pl/sql procedure, will i exit the procedure itself, or i will just return out of the block tat contain the return statement ?

3) if i put a return in a exception area, where will i return to ? out of the procedure or ?

for e.g
create procedure xxx ( a varchar2, b ... so on)
if (...) then
return ------------------ when will i return to?
end if;
when no_data found then
-------------- so when will i return to ?
when others then
RETURN --------------- so when will return to ?
end if;

thanks folk.
Re: PL/SQL out parameter and Return [message #300093 is a reply to message #300089] Thu, 14 February 2008 03:54 Go to previous message
Michel Cadot
Messages: 63956
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1) Yes
2) It exits the procedure
3) Out of the procedure

Previous Topic: pl/sql table vs nested table
Next Topic: IN vs. EXISTS
Goto Forum:

Current Time: Fri Oct 28 15:43:05 CDT 2016

Total time taken to generate the page: 0.09474 seconds