ODBC and OCI to call stored procedures, help

Hi,

    I'm developing tools on an NT platform which are attempting to call stored
procedures in an Oracle 7 database. The tools can be configured to use either
OCI or ODBC (Visigenic) interface to access the database.

    I am having problems trying to call a stored procedure (any suggestions/help
would be appreciated)

    Using OCI, I am able to call a stored procedure if the statement for the procedure is a PL/SQL block. ie "BEGIN proc_name(:1, :2, :3); END;" Is it possible to call a stored procedure in OCI using a call statement?

ie "call proc_name(:1, :2, :3)"?

    Using ODBC, I am unsuccessful trying to execute a call statement for
a procedure. I issue SQLBindParameter calls for both the input and output
parameters followed by an SQLExecDirect of the "call proc_name statement". This results in an error code of 900 (from Visigenic - illegal SQL statement).
I've attempted this same sequence using the embedded PL/SQL statement that I used with OCI. This was still unsuccessful. Although the SQLExecDirect
call returned with a SQL_SUCCESS status, the output from te procedure remains
blank.

Any suggestions for calling stored procedures from ODBC?

Thanks In Advance,
Carole Godfrey Received on Thu Mar 20 1997 - 00:00:00 CST