Re: Returning values to client program

In article <BIS27.6983$B5.269690_at_monolith.news.easynet.net>, "Benetnasch" says...
>
>Can one return a value from Oracle to a "front end" - using O7,
>unfortunately - using something other than recordsets?
>
>What I'd like to be able to do is for the client to fire off a
>bit of code which can return a value to the client without
>the need for a recordset.
>
>I know you can do it in O8 with REF CURSORs, but we're
>in the middle ages here... ;-)
>

well, you can do it in 7 with ref cursors as well -- they were introduced in 7.2 of the database.

You may use a PLSQL function or procedure, every language I've seen ("front end" is very vague here, not sure what you might be using but it sounds like VB since you use the term "recordsets") including VB supports them.

>Thanks for any help.
>
>--
>Benetnasch
>Remove ".spam.begone"
>
>

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp