Difference VS2003 & 5 accessing ORA SP

[roberthagan]

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?

 

[roberthagan]

Forgot. I'm using the Microsoft Oracle data provider in both VS 2003 and 2005, not the Oracle one. Would that make a difference