I've inherited old 2.x framework code.
I am adding a parameter for an oracle database:
ObjCommand.CommandType = CommandType.StoredProcedure
ObjCommand.Parameters.Add("e_this", OracleType.VarChar, 10).Value = strThis
It errors saying "OracleType" is not declared.
It suggests I import system.data.oracleclient.
But this won't work:
Because the function is looking for an Oracle.DataAccess.Client.OracleDbType
If I try this:
It says varchar is not a member of OracleDbType.
What do I do?
If I change it to: OracleDbType.Varchar2 will that hurt anything?
I also have:
Which is errors. How do I pass in a cursor type?
I tried this:
ObjCommand.Parameters.Add("result_cursor", System.Data.OracleClient.OracleType.Cursor).Direction = ParameterDirection.Output
This does work, but there is no 3rd parameter, and the type the function is looking for is an object.
Should I do it that way for the cursor?