Launch application_info before sql Query

[#1]

Hello everyone,

i have a script that need to execute this piece of sql code before performing the select via odbc to the database:

BEGIN

dbms_application_info.set_client_info (151);

END;

if this operation is not performed the select wont pick all the data in the table. I searched the community but could not find any information related to this kind of issue.

Thank you in advance,

Juan Pedro

[Gysbert_Wassenaar]

Perhaps like this:

SQL EXECUTE dbms_application_info.set_client_info (151);

SQL SELECT ... FROM etc...';

But I don't really know, so perhaps you need to ask your local friendly DBA to create a proper stored procedure for you that you can call.

[#3]

Hello and thanks for the fast reply.

I tried what you suggested and inserted the sql execute before the select statement.

The execute statement throws this error.

The query is still executed correctly.

will check if is it a true syntax error