Skip to Main Content

SQL & PL/SQL

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!

Call a procedure in the package dynamically with "invalid SQL statement"

Dee102Dec 1 2021

When I "exec MAIN('ABC01');" from Editor, I received error "ORA-00900: invalid SQL statement" on the line "EXECUTE IMMEDIATE (ExecProd);" I looked up on the internet. It seems a correct command. What was wrong? Thanks.

PROCEDURE Main(HQ varchar2) AS
ExecProd varchar2(100);
BEGIN
ExecProd := HQ || 'Detail;';
dbms_output.put_line(ExecProd);
EXECUTE IMMEDIATE (ExecProd);
END Main;

PROCEDURE ABC01Detail AS
BEGIN
dbms_output.put_line('Here');
END ABC01Detail;

This post has been answered by Frank Kulash on Dec 1 2021
Jump to Answer
Comments
Post Details
Added on Dec 1 2021
8 comments
956 views