ADO.net using ODBC and oracle
From: shania (uramnath_at_hotmail.com)
Date: 05/14/04
- Next message: Paul Clement: "Re: Listing all the tables in MS access Databsae using ODBC"
- Previous message: Paul: "Re: Stored procedure on server-strep through from .NET?"
- Next in thread: Roy Fine: "Re: ADO.net using ODBC and oracle"
- Reply: Roy Fine: "Re: ADO.net using ODBC and oracle"
- Messages sorted by: [ date ] [ thread ]
Date: 14 May 2004 07:59:29 -0700
Hi,
I am trying to execute a simple oracle stored procedure that has an
output parameter, using odbc and ado.net. Here is the code
cSqlOdbcCmd = objConnect.CreateCommand()
cSqlOdbcCmd.CommandType = CommandType.StoredProcedure
cSqlOdbcCmd.CommandText = "packagename.Procedurename"
cSqlOdbcCmd.Parameters.Add("outResult",
OdbcType.Numeric).Direction
= ParameterDirection.Output
objConnect.Open()
cSqlOdbcCmd.ExecuteNonQuery()
The oracle client version is 8.05 and the server version is 8i
(release 8.1.5). I keep getting an invalid sql statement. The same
runs in vb6 ado (with similar call) just fine. I checked for
packagename and procedure name mismatches but there were none. I have
odbc set up propery along with net 8 client. Everytime it goes to the
executenonquery statement it gives an invalid sql statement error. I
also tried to execute simple text sql statments (not stored
procedures) which did not have any problems.
What could be wrong?
Thanks
- Next message: Paul Clement: "Re: Listing all the tables in MS access Databsae using ODBC"
- Previous message: Paul: "Re: Stored procedure on server-strep through from .NET?"
- Next in thread: Roy Fine: "Re: ADO.net using ODBC and oracle"
- Reply: Roy Fine: "Re: ADO.net using ODBC and oracle"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
