ORA-01008: not all variables bound

[katsifos]

oops ,
.sql extention is was not allowed and it is not uploaded
Sorry

[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.

[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

[Alex K.]

Hello,

We need some additional time for check dotConnect for Oracle provider. We will let you know about the result.

Thank you.

[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.

[Alex K.]

Hello,

Please try to add this option in StiOracleODPSource in UpdateParamaters method in OracleODP adapter.

Thank you.

[katsifos]

thank you very much !!!
it works perfect now.
Regards

[Andrew]

Hello,

Great! Have a nice day!