Link to home
Start Free TrialLog in
Avatar of Starr Duskk
Starr DuskkFlag for United States of America

asked on

OracleDbType for varchar and Cursor

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:
System.Data.OracleClient.OracleType.VarChar
Because the function is looking for an Oracle.DataAccess.Client.OracleDbType

If I try this:
Oracle.DataAccess.Client.OracleDbType.VarChar
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:
OracleType.Cursor

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?

thanks.
ASKER CERTIFIED SOLUTION
Avatar of Dirk Haest
Dirk Haest
Flag of Belgium image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Starr Duskk

ASKER

But you did'n answer the question. What is the comparable type for "varchar" and "cursor"?

OracleDbType.Varchar2 and refcursor?