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/