Skip to Main Content

query works in sql developer but does not work on sql plus

User_0UWMNSep 19 2022 — edited Sep 19 2022

Here is an interesting question I am using oracle 18c.
I have a script that runs fine in sql developer but hangs when I try to run in sql plus? Here is the script:
DECLARE
v_carrier_name varchar2(30) := 'POLAR';
v_profile_name varchar2(30) := 'POLAR Import';
v_carrier_id RAW(16);
v_profile_id varchar2(10);
BEGIN
select carrier_id, profile_id
into v_carrier_id, v_profile_id
from accum.profile_carriers
where profile_if in ( select profile_id from accum.profiles
where profile_name = v_profile_name)
and carrier_code = v_carrier_name;
MAKING CALL TO A PROCEDURE below ( **here it gets struck**)
accum.profile_manager. add_profile_group(v_carrier_id, '8087ZEP06', 'Y', 'N');
END;

Comments
Post Details
Added on Sep 19 2022
1 comment
22 views