Skip to Main Content

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!

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 16 2002
Added on Apr 18 2002
4 comments
2,584 views