I have created a direct copy of an existing database. I imported all the schemas successfully, and now I am trying to re-create the materialized views.
Some of the views rely on a package that has problems compiling in the replica database but not in the original database. The exact error received is:
ORA-06553: PLS-103: Encountered the symbol "PAREN" when expecting one of the following:
<an identifier> <a double-quoted delimited-identifier>
ORA-06553: PLS-112: end-of-line in quoted identifier
I have tried compiling it from sql*plus and from within a script but the same error occurrs. I tried compiling only the header, and then the body, but the error remains in both.
The error would normally be rather self-explanatory, but when I open it in the SQL editor in Toad I am told the error is in the first line, which is "CREATE OR REPLACE PACKAGE <schema>.<package_name>".
This makes no sense to me at all! Can anyone help?
p.s. Oracle version is 9i