-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: SukhCSharp
Message 1 in Discussion
Hi,
I am able to execute store proc using MSDAORA Provider but when I use
oraclecommand I get the error "ORA-01036: illegal variable name/
number"
Here is my code:
ORACON = new OracleConnection("Data Source=DB1;User
ID=U1;Password=p1;");
ORACOM = new OracleCommand("SP_Name", ORACON);
ORACOM.CommandType = CommandType.StoredProcedure;
ORACOM.Parameters.Add("@P1", OracleType.Int32);
ORACOM.Parameters["@P1"].Value = 26603;
ORACOM.Parameters.Add("@P2", OracleType.Int32);
ORACOM.Parameters["@P2"].Direction =
ParameterDirection.Output;
ORACON.Open();
ORACOM.ExecuteNonQuery();
The following code is working fine
OleDbConnection OLDBCON = new OleDbConnection("Provider = MSDAORA.
1;Data Source=DB1;User ID=U1;Password=p1;");
OleDbCommand ORACOM = new OleDbCommand("SP_Name",
OLDBCON);
ORACOM.CommandType = CommandType.StoredProcedure;
ORACOM.Parameters.Add("@P1", OleDbType.Integer);
ORACOM.Parameters["@P1"].Value = 26603;
ORACOM.Parameters.Add("@P2", OleDbType.Integer);
ORACOM.Parameters["@P2"].Direction =
ParameterDirection.Output;
OLDBCON.Open();
ORACOM.ExecuteNonQuery();
Can any one help me why its throwing error.
Note: database is oracle 10g.
Regards,
Sukh.
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/BDotNet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member
Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you
received this message by mistake, please click the "Remove" link below. On the
pre-addressed e-mail message that opens, simply click "Send". Your e-mail
address will be deleted from this group's mailing list.
mailto:[EMAIL PROTECTED]
