Skip to Main Content

Oracle Developer Tools 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!

An error occurs when using the ‘Execute All’ feature to run the following code

henry_hooAug 30 2024 — edited Aug 30 2024

An error occurs when using the ‘Execute All’ feature to run the following code, but it works perfectly fine with sqlplus:
DEFINE MODULE = INVENT
DEFINE LU = InvPartNissReqLine
DEFINE VIEW = INV_PART_NISS_REQ_LINE
COMMENT ON TABLE &VIEW
IS 'LU=&LU^PROMPT=Inv Part Niss Req Line^MODULE=&MODULE^';

Error:

SQL> DEFINE MODULE = INVENT

SQL> DEFINE LU = InvPartNissReqLine

SQL> DEFINE VIEW = INV_PART_NISS_REQ_LINE

SQL> COMMENT ON TABLE &VIEW
2 IS 'LU=&LU^PROMPT=Inv Part Niss Req Line^MODULE=&MODULE^';
COMMENT ON TABLE &VIEW
*
ERROR at line 4:
ORA-00903: invalid table name
https://docs.oracle.com/error-help/db/ora-00903/

This post has been answered by Christian.Shay -Oracle on Aug 30 2024
Jump to Answer
Comments
Post Details
Added on Aug 30 2024
3 comments
244 views