APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Import application directly from exported clob?

Scott WesleyJan 5 2012 — edited Apr 23 2012

Does anyone know if it is possible to import an apex application by executing the exported clob as a ddl?

ie - export the application to clob via wwv_flow_utilities.export_application_to_clob
then use execute immediate on the clob

I tried this with an export that executed fine as a script in SQL*Plus

First I received

Error report:
ORA-00922: missing or invalid option
ORA-06512: at "SYS.DBMS_SQL", line 1216
ORA-06512: at line 36
00922. 00000 -  "missing or invalid option"
*Cause:    
*Action:

Then I tried removing the first 5 lines of the script

set define off
set verify off
set serveroutput on size 1000000
set feedback off
WHENEVER SQLERROR EXIT SQL.SQLCODE ROLLBACK

by adding

if i = 1 then 
  v_sql(i) :=  substr(v_sql(i),124);
end if;

to the script using dbms_sql here
10070856

Then I received this:

Error report:
ORA-06550: line 3, column 1:
PLS-00103: Encountered the symbol "/" 
ORA-06512: at "SYS.DBMS_SQL", line 1216
ORA-06512: at line 36
06550. 00000 -  "line %s, column %s:\n%s"
*Cause:    Usually a PL/SQL compilation error.
*Action:

So the ultimate question I guess would be can you execute multiple DDL statements in a VARCHAR2/CLOB ?

Scott