roberthagan
Technical User
I'm converting a report project from VS2003 to 5.
I have some data access code that calls an oracle stored procedure and returns a ref cursor. The backend is 8.0.5, and the client is 8.1.7.
OracleCommand cm = new OracleCommand();
cm.Connection = cn;
cm.CommandType = CommandType.StoredProcedure;
cm.CommandText = "PK_COMPLIANCE.GET_WKR_COMPLIANCE";
cm.Parameters.Add("io_CLIENT", OracleType.Cursor).Direction = ParameterDirection.Output;
cm.Parameters.Add("p_WKR_KEY", OracleType.VarChar).Value = "KA009" ;
cm.Parameters["p_WKR_KEY"].Direction=ParameterDirection.Input;
OracleDataAdapter MyDataAdapter = new OracleDataAdapter(cm);
DataSet MyDataSet = new DataSet("Client");
MyDataAdapter.Fill(MyDataSet );
The code works fine in 2003 and in 5 says.
"ORA-06550 Identifier PK_COMPLIANCE.GET_WKR_COMPLIANCE must be declared.
What is the difference? How do I fix it?
I have some data access code that calls an oracle stored procedure and returns a ref cursor. The backend is 8.0.5, and the client is 8.1.7.
OracleCommand cm = new OracleCommand();
cm.Connection = cn;
cm.CommandType = CommandType.StoredProcedure;
cm.CommandText = "PK_COMPLIANCE.GET_WKR_COMPLIANCE";
cm.Parameters.Add("io_CLIENT", OracleType.Cursor).Direction = ParameterDirection.Output;
cm.Parameters.Add("p_WKR_KEY", OracleType.VarChar).Value = "KA009" ;
cm.Parameters["p_WKR_KEY"].Direction=ParameterDirection.Input;
OracleDataAdapter MyDataAdapter = new OracleDataAdapter(cm);
DataSet MyDataSet = new DataSet("Client");
MyDataAdapter.Fill(MyDataSet );
The code works fine in 2003 and in 5 says.
"ORA-06550 Identifier PK_COMPLIANCE.GET_WKR_COMPLIANCE must be declared.
What is the difference? How do I fix it?