Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2012

    Question Unanswered: spool get_ddl result to file problem

    I want to extract ddl's for all objects(procedures, functions, triggers, packages) on a separate file as in thread:

    I'm using
    Spool &1..&2..sql 
     Select dbms_metadata.get_ddl('&2','&1','TEST' ) from dual;
    Spool off;
    The result is a file but problem is that only first part of code are inserted.
    I have tried to use set linesize and set long etc but I still cannot get the whole thing.

    If I just execute
    Select dbms_metadata.get_ddl('PACKAGE','BIG_TEST_PACKAGE','TEST' ) from dual;
    I get all 483 rows but if I spool it to file it only gives me first 116 rows.

    Can someone help me please?

  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    set lines 4000 long 32000
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Nov 2012
    That doesn't change anything.

    Maybe I should say that I'm using sqldeveloper 3.2. I don't know if that changes anything.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts