There is an extended task out there that I use to do pl/sql from files.
Ant's sql task never liked pl/sql because it treats the statment as a
single line statement regardless of the line feeds.
Michael Medwith
Flagstar Bank
Wholesale Web Development Team
|---------+---------------------------->
| | Tony Obermeit |
| | <[EMAIL PROTECTED]|
| | > |
| | |
| | 02/09/2003 06:53 |
| | PM |
| | Please respond to|
| | "Ant Users List" |
| | |
|---------+---------------------------->
>------------------------------------------------------------------------------------------------------------------------------|
|
|
| To: Ant Users List <[EMAIL PROTECTED]>, Martin
<[EMAIL PROTECTED]> |
| cc:
|
| Subject: Re: creating pl/sql package in sql task, only part of package
loaded |
>------------------------------------------------------------------------------------------------------------------------------|
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 <[EMAIL PROTECTED]> 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"
> <[EMAIL PROTECTED]>
> To: "Ant Users List" <[EMAIL PROTECTED]>;
> <[EMAIL PROTECTED]>
> 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" <[EMAIL PROTECTED]>
> > To: "Ant Users List" <[EMAIL PROTECTED]>
> > 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
> <[EMAIL PROTECTED]>
> > > wrote:
> > > >
> > > > You might want to try to do first the package
> header
> > > > creation, then the
> > > > package body
> > > > Antoine
> > > > ----- Original Message -----
> > > > From: "Tony Obermeit" <[EMAIL PROTECTED]>
> > > > To: <[EMAIL PROTECTED]>
> > > > 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:
> > > > [EMAIL PROTECTED]
> > > > > For additional commands, e-mail:
> > > > [EMAIL PROTECTED]
> > > > >
> > > >
> > > >
> > > >
> > >
>
---------------------------------------------------------------------
> > > > To unsubscribe, e-mail:
> > > > [EMAIL PROTECTED]
> > > > For additional commands, e-mail:
> > > > [EMAIL PROTECTED]
> > > >
> > > >
> > > >
> > >
> > >
> > >
> __________________________________________________
> > > Do you Yahoo!?
> > > Yahoo! Mail Plus - Powerful. Affordable. Sign up
> now.
> > > http://mailplus.yahoo.com
> > >
> > >
>
---------------------------------------------------------------------
> > > To unsubscribe, e-mail:
> [EMAIL PROTECTED]
> > > For additional commands, e-mail:
> [EMAIL PROTECTED]
> > >
> >
> >
> >
>
---------------------------------------------------------------------
> > To unsubscribe, e-mail:
> [EMAIL PROTECTED]
> > For additional commands, e-mail:
> [EMAIL PROTECTED]
> >
>
>
---------------------------------------------------------------------
>
=== message truncated ===
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
This e-mail may contain data that is confidential, proprietary or "non-public
personal information", as that term is defined in the Gramm-Leach-Bliley Act
(collectively, "Confidential Information"). The Confidential Information is
disclosed conditioned upon your agreement that you will treat it
confidentially and in accordance with applicable law, ensure that such data
isn't used or disclosed except for the limited purpose for which it's being
provided and will notify and cooperate with us regarding any requested or
unauthorized disclosure or use of any Confidential Information. By accepting
and reviewing the Confidential Information you agree to indemnify us against
any losses or expenses, including attorney's fees that we may incur as a
result of any unauthorized use or disclosure of this data due to your acts or
omissions. If a party other than the intended recipient receives this e-mail,
you are requested to instantly notify us of the erroneous delivery and return
to us all data so delivered.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
