Stored Procedures and VB - Follow up Question

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 Aug 26 1998 - 12:06:49 CDT