Re: Stored Procedures and VB

On 26 Aug 1998 15:31:41 GMT, 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.
>

I believe the required sql string is 'begin dbms_system.function(); end;'

Note there is no semi-colon after the begin keyword. Received on Wed Aug 26 1998 - 12:04:46 CDT