VB, ODBC and Stored Procedures

From: Hugo Sepulveda R. <hsepulve_at_lauca.usach.cl>
Date: Thu, 21 Jul 1994 23:53:02 GMT
Message-ID: <1994Jul21.235302.2669_at_lauca.usach.cl>


Hi everybody

I 'm also working VB Version and ODBC ORACLE 7 driver to connect to RDBMS ORACLE V7. I' m using SQLnet V.1.1.7.8 and ORACLE 7 ODBC driver.

I'm triying to execute stored procedure.

I tried using the statement execute, as follows;

        EXECUTE <stored-procedure-name> <(parameter1,...parametern)>

        in the property record_source of data_control object, but the driver interprets this sentence as an SQL statement (select, insert, update) and doesn't recognize it.

I know that PowerBuilder V3.0 is able to connect to RDBMS ORACLE V7 using ODBC ORACLE driver and execute stored procedures (at least that said in the manuals because I haven't used it). Could VB with ODBC driver execute stored procedure?

Could anybody helpme?

                        HUGO SEPULVEDA REYES Ps: I haven't the ODBC API, only driver. Received on Fri Jul 22 1994 - 01:53:02 CEST

Original text of this message