PL/SQL can return multiple values - look up IN/OUT and OUT parameters.
Use those to return your data values.

An alternative would be to use the PL/SQL exceptions handling and
create your own errors - as you would in Java or C++. Be warned though
it is not anywhere near as good as in those languages. PL/SQL is
basically ADA which predates those languages by decades.

Alex

>>> "MurliB826"
<oracledba-ezmlmshield-x86965548.[Email address protected] 14/11/2004
10:37:10 pm >>>
I have been asked to write PL/SQL best practices and during the review
of
these practices someone suggested that I should return retrun code of 0
for
success and 1 for fail. I think this is not possible because, if you
were to expect
a value that is a varchar2 to be returned, you return more than one
value to
the calling program.

I will appreciate anyhelp I can get on this.

Thanks,
Michael


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page