Skip to Main Content

SQL Developer for VS Code

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

The first procedure, function in a package cannot be executed.

DataProcessingJul 20 2025

Compile sample package.
Open the Run or Debug dialog.

Select the procedure proc_01_cant_be_invoked and click either [Riun] or [Debug] button.
Nothing happens!

Repeat, select procedure proc_02_can_be_executed and click either [Riun] or [Debug] button.
The procedure is executed.

create or replace package PK_SAMPLE
authid current_user
is
procedure proc_01_cant_be_invoked;
procedure proc_02_can_be_executed;
end;
/

create or replace package body pk_sample
is
procedure proc_01_cant_be_invoked is
begin
sys.dbms_output.put_line('proc_01_cant_be_invoked');
end;

procedure proc_02_can_be_executed is
begin
sys.dbms_output.put_line('proc_02_can_be_executed');
end;

end;
/

Comments
Post Details
Added on Jul 20 2025
1 comment
71 views