ORA-01008: not all variables bound

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

ASP.NET

ORA-01008: not all variables bound

Author

Topic

fan2005
Yak Posting Veteran

85 Posts

Posted - 2010-11-30 : 17:23:10

hi
this is a piece of code :

textBox1.Text = FromDTP.Text;

Connection.Orscom.CommandText =
"SELECT P.abrnchcod||'-'||P.lnminortp||'-'||P.cfcifno||'-'||P.crserial as code,SUM(P.LCBASAMNT)-SUM(LCPNLAMNT)as pardakhte,'1389/06/30' as ta_tarikh" + " " +
"FROM lcpayinf P " +
"WHERE (TO_CHAR(P.lcpaydat,'yyyy/mm/dd','nls_calendar=persian')<= :FromDate) GROUP BY P.abrnchcod||'-'||P.lnminortp||'-'||P.cfcifno||'-'||P.crserial";

OracleParameter myParameter1 = new OracleParameter("FromDate",OracleType.VarChar,10);

myParameter1.Value = textBox1.Text;
myParameter1.Direction = ParameterDirection.Input;
Connection.Orscom.Parameters.Add(myParameter1);

OracleDataAdapter da = new OracleDataAdapter(Connection.Orscom.CommandText, Connection.Orscon);
try
{
Connection.Orscon.Open();
Connection.Orscom.ExecuteNonQuery();
}
catch (OracleException oe1) {; }
finally
{
DataSet dsOracle = new DataSet();
da.Fill(dsOracle, "OracleDT");
Connection.Orscon.Close();
}

when it comes to fill data adapter
da.Fill(dsOracle, "OracleDT");
it throw exception:

please someone help
thanks

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2010-11-30 : 17:36:50

This site is for questions about Microsoft SQL Server.

You should post your question on a site that answers questions about Oracle.

CODO ERGO SUM

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources