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!

Invalid table name error

Hi,

Under Oracle 19c, using Oracle APEX 24, I get the following error (table name not valid):

  • ORA-06550: Ligne 1, colonne 84 : PL/SQL: ORA-00903: nom de table non valide

The statement is :

insert into :P46_ID = (select ID from APEX_APPL_ACL_USERS where USER_NAME = :P46_USER_NAME) ;

APEX_APPL_ACL_USERS is a view that I have not created, it is a view in Oracle APEX.

Best regards.

This post has been answered by Lothar Armbrüster on Oct 17 2025
Jump to Answer
Comments
Post Details
Added on Oct 17 2025
2 comments
86 views