AfterConnect.sql

[LGEAI Developers]

Hi Allroundautomations,

We migrate to PL/SQL Developer 7.0.0.1050, with a short code in AfterConnect.sql, when work with PL/SQL 6.0.6.947 AfterConnect.sql fires fine and all sessions works ok. Now with new version AfterConnect don't fire, can you help me ?

Thanks in advance.

 

[Marco Kalter]

This should work just fine. What exactly do you do in AfterConnect.sql, and how do you determine that it does not execute?

 

[LGEAI Developers]

We execute this code.
DECLARE
--
--
BEGIN
--
INSERT INT TMP_PEDRO (C1, C2)
VALUES (SYSDATE, '1');
COMMIT;
--
END;
/
Regards

 

[Marco Kalter]

Works fine for me. I did change INT to INTO though.

 

[Javo]

Hi there,
I have a problem with my afterConnect script it is not working at all... here is the code:
---------------------------------------------
declare
l_db_name varchar2(40);
begin
--
select global_name into l_db_name from global_name;
if (l_db_name in ('XE')) then
execute immediate 'SET ROLE NONE';
end if;
--
end;
/
-------------------------------------------

The intention is to disable the RESOURCE role, in order not to allow the compilation for certain databases... but it seems that this script is not being executed when connecting, because the select:

select * from session_roles;

still get the assigned roles...

Thanks for your support,

 

[Marco Kalter]

Works fine for me (after chaning the database name). Are you using 7.0.2?

 

[Javo]

This might be the cause I haven't upgraded I have the 7.0.0.1050 version, I will ask the responsible at my company to upgrade the licenses we have.

Thx for your support,