Return-Path: <levylambert@tiscali-dsl.de>
Mailing-List: contact ant-user-help@jakarta.apache.org; run by ezmlm
Delivered-To: mailing list ant-user@jakarta.apache.org
Received: (qmail 81739 invoked from network); 9 Feb 2003 23:09:52 -0000
Received: from unknown (HELO webmail.tiscali.de) (62.27.55.1)
  by daedalus.apache.org with SMTP; 9 Feb 2003 23:09:52 -0000
Received: from DJ0X820J (80.128.234.20) by webmail.tiscali.de (6.0.045)
        id 3E1650CC00D07F27; Sun, 9 Feb 2003 23:53:05 +0100
Message-ID: <000701c2d091$1c3f21d0$030200c0@DJ0X820J>
From: "Antoine Levy-Lambert" <levylambert@tiscali-dsl.de>
To: "Ant Users List" <ant-user@jakarta.apache.org>,
	<tonyob@compuserve.com>
References: <20030209225703.35338.qmail@web12905.mail.yahoo.com>
Subject: Re: creating pl/sql package in sql task, only part of package  loaded
Date: Mon, 10 Feb 2003 00:15:17 +0100
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N

I mean cut your PL/SQL script in two pieces, and invoke the ant sql task
twice :
    - once for the package header,
    - once for the package body
Do you have to inline your PL/SQL in your ant build file, or can you also
use separate files containing the SQL ?
If yes, you should separate your build file from your SQL, it would make
things maybe clearer.
Antoine
----- Original Message -----
From: "Tony Obermeit" <ynotob@yahoo.com>
To: "Ant Users List" <ant-user@jakarta.apache.org>
Sent: Sunday, February 09, 2003 11:57 PM
Subject: Re: creating pl/sql package in sql task, only part of package
loaded


> I believe that is what I'm doing.  Can you clarify
> further?
>
> In the snippet below, the "create package" creates the
> package specification, the "create package body"
> creates the rest of the package.  I would see the
> specification as the same as the "header" you referred
> to.  Is that the same thing?
>
> Tony
>
> > create package
> >
> > ..... (specification)
> >
> > end;
> > /
> >
> > create package body.....
> > 742 lines of code in here, 26kb of text
> >
> > /
> >
>
> --- Antoine Levy-Lambert <levylambert@tiscali-dsl.de>
> wrote:
> >
> > You might want to try to do first the package header
> > creation, then the
> > package body
> > Antoine
> > ----- Original Message -----
> > From: "Tony Obermeit" <tonyob@compuserve.com>
> > To: <ant-user@jakarta.apache.org>
> > Sent: Sunday, February 09, 2003 10:04 PM
> > Subject: creating pl/sql package in sql task, only
> > part of package loaded
> >
> >
> > > Below is a code snippet I use to create a pl/sql
> > package with ant 1.5.1.
> > >
> > > The package specification creates successfully,
> > the package body does not
> > > create, it appears that significant lines of the
> > code are not saved, with
> > > only lines at the start and end of the code being
> > created.  The code is
> > 742
> > > lines which about 26kb of text.  It almost seems
> > like the sax parsing of
> > > the sql text doesn't correctly pick up the middle
> > text.
> > >
> > > Is there a limit to how much pl/sql text can go in
> > to the sql task?  Am I
> > > running the pl/sql creation the way I should?  Any
> > other ideas?
> > >
> > > thanks
> > >
> > > Tony
> > >
> > > <target name  = "create" >
> > >
> > > <sql
> > >              driver  =
> > "oracle.jdbc.driver.OracleDriver"
> > >              url = "${database.jdbc.url}"
> > >              userid = "${database.user}"
> > >              password = "${database.password}"
> > >              print = "true"
> > >              delimiter = "/"
> > >              onerror   = "abort" >
> > >
> > > <![CDATA[
> > >
> > > create package
> > >
> > > ..... (specification)
> > >
> > > end;
> > > /
> > >
> > > create package body.....
> > > 742 lines of code in here, 26kb of text
> > >
> > > /
> > >
> > > ]]>
> > >
> > > </sql>
> > > </target>
> > >
> > >
> > >
> > >
> >
> ---------------------------------------------------------------------
> > > To unsubscribe, e-mail:
> > ant-user-unsubscribe@jakarta.apache.org
> > > For additional commands, e-mail:
> > ant-user-help@jakarta.apache.org
> > >
> >
> >
> >
> ---------------------------------------------------------------------
> > To unsubscribe, e-mail:
> > ant-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail:
> > ant-user-help@jakarta.apache.org
> >
> >
> >
>
>
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> http://mailplus.yahoo.com
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ant-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: ant-user-help@jakarta.apache.org
>