Return
-
Title
Schema prefixes and ROWTYPE declarations -
Description
Issue with ROWTYPE declarations.To replicate:
Steps:) Open Toad, open attached TOAD_TEST.sql2) Click either "Run as Script" or "Compile" and you will recieve the error message as described :ERROR line 10, col 45, ending_line 10, ending_col 45, Found '%', Expecting: ; -or- .. := DEFAULT NOT NULL -or- CHARACTER -or- .3) The statement is perfectly valid - and compiles OK in SQLPLUS.
-
Resolution
WORKAROUND:
None.
STATUS:
Waiting for fix in a future release of Toad for Oracle.
-
Defect ID
CR78185