Calling Stored Procedures

Calling Stored Procedures

Can one call a stored procedure or function in oracle 7through odbc from visual basic? This might be a questionfor an oracle user group, so if you know where I shouldask the question give me a reply.

Stored procedures in Oracle can be executed using the ExecuteSQL method on the database object. However, when I was doing similar things, we ran into problems because cursors don’t work right with Oracle and VB…it doesn’t hold the cursor open for you between fetches, if I remember right. However, simple SQL statements that return no records worked ok.


Share the Post: