Calling Oracle Stored Procedure in VB 
Author Message
 Calling Oracle Stored Procedure in VB

Hi,

A few messages ago, someone mentioned a way to call on Oracle stored
procedure from VB with Q + E Multilink as the 3rd party software. I tried
but it didn't work. Is this the right way?:-

msql$ = "begin sp_name('param1','param2');end;"
result% = fexecsql(query1,msql$)

Please enlighten. Thanx...

Isaac



Tue, 26 May 1998 03:00:00 GMT  
 Calling Oracle Stored Procedure in VB

Quote:
>msql$ = "begin sp_name('param1','param2');end;"
>result% = fexecsql(query1,msql$)

Try the following:
msql$ = "{CALL PROCEDURENAME(PARAM1,PARAM2,PARAM3)}"
result% = fexecsql(query1,msql$)


Sat, 30 May 1998 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Calling Oracle Stored Procedure from VB

2. Calling Oracle Stored Procedure from VB

3. Calling Oracle Store Procedure from VB.

4. Calling Oracle Stored Procedure in VB ?

5. Calling Oracle Stored Procedures from VB

6. How to call an Oracle stored procedure from VB

7. Calling Oracle SQL Stored Procedures from VB

8. Calling an Oracle Stored Procedure from Vb using Q+E

9. Calling a Stored Procedure in Oracle using VB

10. VB/Access to call Stored Procedures in Oracle

11. Calling an Oracle Stored Procedure

12. call Oracle stored procedure from Excel?

 

 
Powered by phpBB® Forum Software