SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Call Oracle Stored Procedure from VB

106972Apr 18 2002

Dear all,

We have difficulties to call Oracle Stored procedure from other vendor development tools.

Any body can help us, We have to integrate our Oracle Application with Visual Basic application. But there is No Oracle SQL command that can call Stored Procedure. Stored procedure just can be call from PL/SQL, and we just can send SQL command from VB.
We just try to change procedure to function and select the function. But unfortunately there are insert statement in our coding, and we can't have dml statement inside query.

I'm just wondering why it's so difficult to integrate oracle database with other vendor development tools ?

Thanks in Advanced

Locked Post

New comments cannot be posted to this locked post.

Locked on May 16 2002

Added on Apr 18 2002

4 comments

2,418 views