SQL Window Question

[mike]

In SQL Plus, I can execute dbms_application_info.set_client_info to query multi-org views and I can put it in the LOGIN.SQL to run it automatically when it starts. It works like that in the command window in PLSQL Developer too.

The login.sql doesn't run for the sql window. Is there a way to run a script in the SQL Window automatically before it opens, or is there another way to do this? If not, it would be nice to have.

Thanks,

Mike

 

[Marco Kalter]

If you create an AfterConnect.sql file in the PL/SQL Developer installation directory, you can add SQL and PL/SQL statements that will be executed for all connections (not just the SQL Window). You cannot use SQL*Plus commands like EXEC though. You would have to use something like this:

begin
  dbms_application_info.set_client_info('my client info');
end;
/

------------------
Marco Kalter
Allround Automations

 

[mike]

Thank-you. That works great.

Mike