Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Difference VS2003 & 5 accessing ORA SP

Status
Not open for further replies.

roberthagan

Technical User
May 9, 2006
27
US
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?
 
Forgot. I'm using the Microsoft Oracle data provider in both VS 2003 and 2005, not the Oracle one. Would that make a difference
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top