Executing long ddls using dynamic sql

From: Juan Carlos Reyes Pacheco <jreyes_at_dazasoftware.com>
Date: Tue, 27 Jul 2004 11:10:59 -0400
Message-Id: <41067083.00000D.01660@CACHITOSS>

 

Hi list I'm investigating this
I'm having problems executin long ddls like this for example  

I need to rund ddls dinamically of packages with more than 20,000 characters  

any idea. (they packages are only one copmlex process and I can't divide in smaller packages)  

execute immediate 'CREATE OR REPLACE
PACKAGE adm.pck_captura2
IS
FUNCTION clt ( cCodigo VARCHAR2, dFecha DATE, nNoProceso NUMBER,cPath VARCHAR2 )
RETURN VARCHAR2;
FUNCTION mco ( cCodigo VARCHAR2, dFecha DATE,nNoProceso NUMBER,cPath VARCHAR2 )
RETURN VARCHAR2;
FUNCTION mde ( cCodigo VARCHAR2, dFecha DATE,nNoProceso NUMBER,cPath VARCHAR2 )
RETURN VARCHAR2;
FUNCTION men ( cCodigo VARCHAR2, dFecha DATE,nNoProceso NUMBER,cPath VARCHAR2 )
RETURN VARCHAR2;
FUNCTION mfa ( cCodigo VARCHAR2, dFecha DATE,nNoProceso NUMBER,cPath VARCHAR2 )
RETURN VARCHAR2;
FUNCTION mpg ( cCodigo VARCHAR2, dFecha DATE,nNoProceso NUMBER,cPath VARCHAR2 )
RETURN VARCHAR2;
FUNCTION mru ( cCodigo VARCHAR2, dFecha DATE, nNoProceso NUMBER,cPath VARCHAR2 )
RETURN VARCHAR2;
FUNCTION msf ( cCodigo VARCHAR2, dFecha DATE,nNoProceso NUMBER,cPath VARCHAR2 )
RETURN VARCHAR2;
FUNCTION mtc ( cCodigo VARCHAR2, dFecha DATE,nNoProceso NUMBER,cPath VARCHAR2 )
RETURN VARCHAR2;
FUNCTION mtr ( cCodigo VARCHAR2, dFecha DATE, nNoProceso NUMBER,cPath VARCHAR2 )
RETURN VARCHAR2;
END; -- Package spec
/';  

Juan Carlos Reyes Pacheco
OCP

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Tue Jul 27 2004 - 10:18:00 CDT