Re: DBMS_METADATA PL/SQL Supplied Package

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 18 2003 - 15:15:42 CEST