Stored Procedures and VB

From: Martin Rapier <M.Rapier_at_shef.ac.uk>
Date: 26 Aug 1998 15:31:41 GMT
Message-ID: <6s19ot$psq$1@bignews.shef.ac.uk>

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

--
Martin Rapier, Database Administrator
Corporate Information & Computing Services. University of Sheffield Tel 0114 222 1137 The opinions expressed here may be those of my employer, or they may not. http://rhino.shef.ac.uk:3001/mr-home/ Received on Wed Aug 26 1998 - 10:31:41 CDT