ERROR Syntax error or access violation

SELECTED ANSWER

replied on May 5, 2020

Hi Robert

Are you sure the syntax of SQL query is correct? I think the Procedure query should look like the below:

begin

laserfiche.fa_insert_petition('1','202020','199404440'); 

end;

1. Please try with Oracle Procedure Call with hard coded parameters.

2. If this query works fine in SQL Plus or SQL developer, check the variables used. Not all the Oracle Variables supports ODBC connection.

3. Try with Oracle Provider for .NET instead of ODBC, which will works well than ODBC provider.

1 0

replied on May 6, 2020

Thanks for your help.

I used the oracle syntax as you described and worked perfectly.

Regards,

0 0

replied on May 6, 2020

I'm pleased that I could help you on this.

Hope you are aware how to pass the parameters to the Procedure!

0 0

Question