Page 1 of 1

OraOLEDB + ORA Error 1008

Posted: Wed Apr 22, 2009 5:37 am
by selbjx
i am trialing your software Reports.Web 2009 version, and recieving the following error:

ORA-01008: not all variables bound

The select statement includes a single variable :IDENT which i am trying to set using:

Code: Select all

StiReport report = StiWebReport1.GetReport();

report.Compile();

report.CompiledReport.DataSources["DataSource1"].Parameters[":IDENT"].ParameterValue = "1000060";

StiWebViewer1.Report = report;
Any suggestions. I am using the ORAOLEDB provider.

OraOLEDB + ORA Error 1008

Posted: Wed Apr 22, 2009 9:48 am
by Jan
Hello,

Please try following code:

Code: Select all

StiReport report = StiWebReport1.GetReport();

report[":IDENT"] = "1000060";

StiWebViewer1.Report = report;
Thank you.

OraOLEDB + ORA Error 1008

Posted: Thu Apr 23, 2009 7:44 am
by selbjx
I ended up using the oracleclient on your website which has worked fine, many thanks

OraOLEDB + ORA Error 1008

Posted: Thu May 07, 2009 5:31 pm
by Edward
Hi,

You are welcome, please let us know if any additional help is required.

Thank you.