Re: Returning values to client program

Any examples of any codes anywhere, please?

Thanks

--
Benetnasch
Remove ".spam.begone"
Thomas Kyte <tkyte_at_us.oracle.com> wrote in message
news:9ihkiq0ah_at_drn.newsguy.com...


> 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

>