Re: dbms_metadata for Synonym

DBMS_METADATA.GET_DDL returns a CLOB. Therefore, just change the value of your variable "long" to a bigger value, and you'll be OK (from SQL*Plus, "set long 50000").

Daniel

wallflowers <member32010_at_dbforums.com> wrote in message news:<3134895.1058810959_at_dbforums.com>...
> I have managed to figure out the solution for the 1st one. All I had to
> do was set filter to the current schema. So please just consider the
> 2nd problem:
> 2. when generating triggers, certain triggers are not being extracted
> completely. I repeat only certain triggers. rest of them are being
> extracted ok. can someone please explain why this is happening and
> how can i avoid it?
>
> Thanks,
> Hari
>
> Originally posted by wallflowers
> > Hi,
> >
> > I am using dbms_metadata for generating all the ddl in the current
> > schema. Although there are a couple of problems i am facing.
> >
> > 1. when i try to generate the ddl for all synonyms, it seems to be
> > generating the ddl for all public synonyms, i need only the ones
> > owned by the current schema. how do i do that?
> >
> > 2. when generating triggers, certain triggers are not being extracted
> > completely. I repeat only certain triggers. rest of them are being
> > extracted ok. can someone please explain why this is happening and
> > how can i avoid it?
> >
> > Any help is highly appreciated. Thanks in advance.
> >
> Hari
Received on Tue Jul 22 2003 - 16:35:49 CEST