Error when running a script with reserved words used as part of alias names. Running the script below in Toad generates an error, however, running it in SQL Plus works fine.
ERROR:
"ERROR line 4, col 39, ending_line 4, ending_col 53, Found 'FROM_TABLE_NAME', Expecting: FROM -or- BULK INTO -or- ,"
=======================================================
CREATE OR REPLACE procedure test
as
CURSOR aCur IS
SELECT USER || '.' || a.TABLE_NAME as FROM_TABLE_NAME
FROM USER_TABLES a;
Begin
FOR cCur IN aCur LOOP
DBMS_OUTPUT.PUT_LINE('FROM TBL: ' || cCur.FROM_TABLE_NAME);
END LOOP;
end;
/
=======================================================
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center