Re: DBMS_METADATA PL/SQL Supplied Package
Date: Fri, 25 Jul 2003 19:28:10 +0200
Message-ID: <1059154096.629375_at_exnews>
Hari,
as Daniel already mentioned, set the LONG value in SQL*Plus to a high value.
Don't forget
to set the size of the increments (chunks) in LONGCHUNKSIZE also to avoid
unintentional
text wrapping. Here's a simple script:
SET HEADING OFF
SET FEEDBACK OFF
SET TERMOUT OFF
SET LONG 99999999
SET LONGCHUNKSIZE 640
SPOOL C:\TEMP\PKG_DUMMY.SQL
SELECT DBMS_METADATA.GET_DDL('PACKAGE','PKG_DUMMY') FROM DUAL;
SPOOL OFF;
Kind regards,
Markus Eltschinger
Swisscom IT Services Ltd
Data Warehouse Development
1752 Villars-Sur-Glāne FR
Switzerland
http://www.swisscom.com/it/content/e-BusinessSolutions/crmdwh7/bidwh/index_EN.html
"Daniel Roy" <danielroy10junk_at_hotmail.com> wrote in message
news:3722db.0307180515.7df3f7b8_at_posting.google.com...
> I've never extracted functions or triggers with that package, but your
> issue might be related with the fact that, if my memory doesn't fail
> on me, the trigger info is stored in a "long" field (in table
> ALL_TRIGGERS), whereas the code for functions is stored in varchar2
> field (in ALL_SOURCE). Try to "set long ..." to a larger value before
> calling DBMS_METADATA.
>
> Just my 2 cents
>
> Daniel
>
> wallflowers <member32010_at_dbforums.com> wrote in message
news:<3124772.1058494266_at_dbforums.com>...
> > Hi,
> >
> > I am using dbms_metadata PL/SQL supplied package to extract all the
> > objects from the oracle database into files. So far I have generated the
> > source code for Functions & Triggers. Functions seems to be absolutely
> > fine. But there seems to be some kind of a problem with Triggers. Some
> > of the triggers were'nt extracted completely and some were. Not quite
> > sure why this is happening. I am using exactly the same code for
> > functions & triggers.
> >
> > Is anybody aware as to what could be the problem. Or if there is a bug
> > with the dbms_metadata package.
> >
> > Any help is highly appreciated.
> >
> > Thanks in advance.
> > Hari
Received on Fri Jul 25 2003 - 19:28:10 CEST