Page 2 of 2
Re: ORA-01008: not all variables bound
Posted: Wed Feb 05, 2014 4:31 pm
by katsifos
oops ,
.sql extention is was not allowed and it is not uploaded
Sorry
Re: ORA-01008: not all variables bound
Posted: Thu Feb 06, 2014 12:23 pm
by Alex K.
Hello,
It is not our error message. This is the issue on the Oracle side. Please try to run this query with the OracleDataAdapter in your project, you get the same message. In this case you need to check the Oracle documentation to fix this issue.
Thank you.
Re: ORA-01008: not all variables bound
Posted: Thu Feb 06, 2014 3:53 pm
by katsifos
yes correct this is oracledataccess provider error . post it to oracle support.
try the same code as above and with devart provider for oracle and passes correct.
Is it possible to connect stimulsoft with devart provider for oracle and not dot connect universal of devart.
Regards
Re: ORA-01008: not all variables bound
Posted: Fri Feb 07, 2014 7:05 am
by Alex K.
Hello,
We need some additional time for check dotConnect for Oracle provider. We will let you know about the result.
Thank you.
Re: ORA-01008: not all variables bound
Posted: Wed Feb 12, 2014 4:23 pm
by katsifos
After a lot of consulting
The statement passe if set
OracleCommand.BindByName = true ;
for odp.net adapter. ODP.NET bind by position (default) for parameter binding .
How is it Possible to enable it from StiOracleOdp in Report ?
Regards.
Re: ORA-01008: not all variables bound
Posted: Thu Feb 13, 2014 8:42 am
by Alex K.
Hello,
Please try to add this option in StiOracleODPSource in UpdateParamaters method in OracleODP adapter.
Thank you.
Re: ORA-01008: not all variables bound
Posted: Thu Feb 13, 2014 1:42 pm
by katsifos
thank you very much !!!
it works perfect now.
Regards
Re: ORA-01008: not all variables bound
Posted: Fri Feb 14, 2014 4:06 am
by Andrew
Hello,
Great! Have a nice day!