|
-
Sep 9th, 2004, 05:17 AM
#1
Thread Starter
New Member
Executing an Oracle stored procedure using ODBC
I'm trying to execute an Oracle stored procedure in a VB.Net application. The code I am using is as follows:
Dim conn As New System.Data.Odbc.OdbcConnection
Dim ds As New DataSet
Try
conn.ConnectionString= "DSN=CO51D;uid=aasc;pwd=aasc"
conn.Open()
Dim mycmd As New OdbcCommand
mycmd.Connection = conn
mycmd.CommandText = "jonny"
mycmd.CommandType = CommandType.StoredProcedure
mycmd.ExecuteReader()
Catch x As Exception
MessageBox.Show(x.Message.ToString)
End Try
THe error message I get is ORA-00900; invalid SQL statement
yet the stored procedure works fine within a VB6 application.
Has anyone any suggestions or encountered anything similar?
Thanks
vbdotnetter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|