Hi All, I have a oracel database, and in that ihave one SP whcih is having a Cursor type as o/p parameter. Now from front end i.e using asp.net i am using ODBC connection. I want to pass this Cursor type as o/p parameter to ODBC connection but in ODBC.ODCbcTYpe does not have the cursor or Ref cursor type So how can i do this.?? Dim cnnODBCConnection As OdbcConnection = New System.Data.Odbc.OdbcConnection("DSN=dsShopCart;Uid=UID;Pwd=PASS") Dim getData_Cmd As OdbcCommand = New OdbcCommand("CUSTOMER_CLEANSING_Display.CM_APPROVER", cnnODBCConnection) getData_Cmd.CommandType = CommandType.StoredProcedure Dim param_Description As OdbcParameter = getData_Cmd.Parameters.Add("RefCursor", ??) param_Description.Direction = ParameterDirection.Output Alert

Hi All, I have a oracel database, and in that ihave one SP whcih is having a Cursor type as o/p parameter. Now from front end i.e using asp.net i am using ODBC connection. I want to pass this Cursor type as o/p parameter to ODBC connection but in ODBC.ODCbcTYpe does not have the cursor or Ref cursor type So how can i do this.?? Dim cnnODBCConnection As OdbcConnection = New System.Data.Odbc.OdbcConnection("DSN=dsShopCart;Uid=UID;Pwd=PASS") Dim getData_Cmd As OdbcCommand = New OdbcCommand("CUSTOMER_CLEANSING_Display.CM_APPROVER", cnnODBCConnection) getData_Cmd.CommandType = CommandType.StoredProcedure Dim param_Description As OdbcParameter = getData_Cmd.Parameters.Add("RefCursor", ??) param_Description.Direction = ParameterDirection.OutputAlert

Hi GauriAShitre, Thanks for the question. Please understand we consult SQL Server Reporting Services questions in this forum mainly. For your problem, I would suggest you submit one new thread in our another forum: Oracle, MySQL, Sybase, Informix and other databases Thanks for the understanding again. Sharp WangPlease remember to mark the replies as answers if they help you and unmark them if they provide no help.

Hi GauriAShitre, Thanks for the question. Please understand we consult SQL Server Reporting Services questions in this forum mainly. For your problem, I would suggest you submit one new thread in our another forum: Oracle, MySQL, Sybase, Informix and other databases Thanks for the understanding again. Sharp WangPlease remember to mark the replies as answers if they help you and unmark them if they provide no help.

Hi GauriAShitre, Thanks for the question. Please understand we consult SQL Server Reporting Services questions in this forum mainly. For your problem, I would suggest you submit one new thread in our another forum: Oracle, MySQL, Sybase, Informix and other databases Thanks for the understanding again. Sharp WangPlease remember to mark the replies as answers if they help you and unmark them if they provide no help.

You have to solve the problem?