Calling Stored Procedures

Question:
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.

Answer:
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:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: