You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ant.apache.org by Martin <mg...@hotmail.com> on 2002/08/16 22:16:25 UTC
Re: creating pl/sql package in sql task, only part of package loaded
Tony-
1)which DTD are you using?
2)Could you use src=packagecreate.sql (place your create package statements
into the sql?)
Thanks,
Martin
----- Original Message -----
From: "Antoine Levy-Lambert" <le...@tiscali-dsl.de>
To: "Ant Users List" <an...@jakarta.apache.org>; <to...@compuserve.com>
Sent: Sunday, February 09, 2003 7:15 PM
Subject: Re: creating pl/sql package in sql task, only part of package
loaded
> 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" <yn...@yahoo.com>
> To: "Ant Users List" <an...@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 <le...@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" <to...@compuserve.com>
> > > To: <an...@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
> >
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ant-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: ant-user-help@jakarta.apache.org
>
Re: creating pl/sql package in sql task, only part of package loaded
Posted by Tony Obermeit <yn...@yahoo.com>.
I don't understand what you are asking in your
question about which DTD I'm using. I haven't
specified a dtd in my build.xml document. My
build.xml only has a project element in addition to
the target and sql elements. I've never specified a
DTD when using ant scripts. Please clarify?
I can use the src=packagecreate.sql if absolutely
necessary but I'd really prefer not to. I currently
deploy an application using ant as the tool to create
all my oracle database objects. I want to keep this
script as simple as possible. At the moment I am
deploying my application as a single jar file and it
has to have a single build.xml distributed with it.
If I could, I would also bundle my build.xml within
the jar file but I've separately confirmed that this
isn't possible at the moment with ant.
Thanks for your reply,
Tony
--- Martin <mg...@hotmail.com> wrote:
>
> Tony-
> 1)which DTD are you using?
> 2)Could you use src=packagecreate.sql (place your
> create package statements
> into the sql?)
> Thanks,
> Martin
>
> ----- Original Message -----
> From: "Antoine Levy-Lambert"
> <le...@tiscali-dsl.de>
> To: "Ant Users List" <an...@jakarta.apache.org>;
> <to...@compuserve.com>
> Sent: Sunday, February 09, 2003 7:15 PM
> Subject: Re: creating pl/sql package in sql task,
> only part of package
> loaded
>
>
> > 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" <yn...@yahoo.com>
> > To: "Ant Users List" <an...@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
> <le...@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" <to...@compuserve.com>
> > > > To: <an...@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
> > >
> >
> >
> >
>
---------------------------------------------------------------------
> > To unsubscribe, e-mail:
> ant-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail:
> ant-user-help@jakarta.apache.org
> >
>
>
---------------------------------------------------------------------
>
=== message truncated ===
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com