To call Oracle stored procedures with ND, use the Oracle SQL net drivers
rather than ODBC.
You can call Oracle stored procedures from VB with ODBC, but with ND SQL net
may be necessary.
Brendan
TeamND
-----Original Message-----
From: Ray Alpaugh [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 06, 1999 2:44 PM
To: [EMAIL PROTECTED]
Subject: [ND] Calling an Oracle Stored Procedure
When using the Data Object wizard to create a data object
with data access type
"Procedure", after entering the owner name, the hierarchy of
procedures to choose
from does not include ALL the stored procedures in the
Oracle database. And then
when I select one I get the following error:
Error Code: 5
Error Message: SQL call failed.
Vendor Code 1: 0
Vendor Message 1: S1C00
Vendor Code 2: 1
Vendor Message 2: [Oracle][ODBC Oracle Driver]Driver not
capable.
My data source uses the Oracle73 ODBC driver, version
2.00.0301.
Does this error imply the Oracle73 driver cannot access
stored procedures? And if so,
what Oracle driver (version) can that is compatible with a
v7.3.3 database?
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the
discussion
forums, please go to:
http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
