Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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