Application Import Error - ORA-20001
430149Dec 12 2005 — edited Jan 6 2006All,
I exported an application and then tried to import it into the same workspace schema with an auto-assign APP ID. I'm getting the error below. I have exported and imported this application many times, but this is the first time I have encountered this issue. This error started occurring after I added 12 new pages. I can't figure out which page is causing the problem. I also attempted to install the export file into several different HTML DB instances with no success.
ORA-20001: GET_BLOCK Error. ORA-20001: GET_STMT error. ORA-20001: Execution of the statement was unsuccessful. ORA-06550: line 16, column 1: PLS-00103: Encountered the symbol "0" when expecting one of the following: ) , * & | = - + < / > at in is mod not rem => .. <an exponent (**)> <> or != or ~= >= <= <> and or like as between from usin
1. Database: 9.2.0.6
2. HTML Version: 1.6.0.00.87
3. NLS_CHARACTERSET WE8ISO8859P1
4. DAD CHARACTERSET UTF-8
I noticed that my database characterset and my DAD characterset were different, so I changed my DAD characterset and bounced Apache and tried the export import again. It failed with the same error.
Any help would be appreciated, I'm really stuck...I need to get this updated app into production.