Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Stored Procedures and VB - Follow up Question
The new Oracle Objects for OLE (oo4o22) will lett you return a cursor as a
read only dynaset object.
Have fun,
Darren
CaseMan wrote in message <35e4402a.22708663_at_news.tiac.net>...
>Is it possible to retrieve information via a pl/sql procedure into VB?
>I am particularly interested into multirecords results.
>Is there any way to use a cursor variable?
>
>Dave Roth
>
>
>M.Rapier_at_shef.ac.uk (Martin Rapier) wrote:
>
>>I know that this one comes up time and time again, but could someone
remind me
>>how to call a stored procedure from Visual Basic?
>>
>>Ordinary SQL is no problem, but I want to modify an old VB system
>>monitor program a colleague wrote to allow me to execute
>>dbms_system.set_sql_trace_in_session for user sessions. I believe you have
to
>>muck around explicitly embedding 'begin' & 'end' statements terminated by
>>CR/LFs?? A code example would be v. handy.
>>
>>Cheers
>>Martin
>
Received on Wed Sep 02 1998 - 23:29:04 CDT