You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ant.apache.org by Jose Alberto Fernandez <ja...@cellectivity.com> on 2003/02/25 12:00:25 UTC
RE: creating pl/sql package in sql task, only part of package lo aded
Rob,
Would it be possible to incorporate your changes into the <sql> task
instead of defining a completely new task?
I use <sql> to add my PLSQL code and I achieve that by defining a separate
delimiter (in my case ";;") Then the SQL task will collect all the stuff intil
it finds a ";;" and send it to ORACLE in one go, which solves the issue of getting
the code in.
The next issue if loosing the formatting of the code. Which I am responsible for
removing since some stupid RDBMSs do not like new-lines. What we need is just a
new attribute (suggested name "keepFormat") default to false (for backward compatibility)
that just controls whether new lines should be removed or not. The attribute will make conditional
all the lines in the code that you have just comment out.
My point on this is that such a solution would be much more easy to maintain the code
that having a complete separate copy of the code.
Jose Alberto
> -----Original Message-----
> From: Anderson, Rob H - VSCM [mailto:Anderson.Rob@vectorscm.com]
> Sent: 11 February 2003 21:47
> To: 'Ant Users List'; ant-dev@jakarta.apache.org
> Subject: RE: creating pl/sql package in sql task, only part of package
> lo aded
>
>
> Tony, Thanks for the feedback. I'm glad to hear that it is
> working for your
> needs. Hopefully others will feel the same. I'm new to
> contributing to this
> project, so I'm not sure what the likelyhood of this task
> making into the
> dist is. Anyway, I will repost it to this list as needed. I
> encourage anyone
> who thinks this should make it into the dist to go to
> bugzilla and vote for
> Bug# 16945.
>
> Robert Anderson
> Configuration Manager
>
>
> -----Original Message-----
> From: Tony Obermeit [mailto:tonyob@compuserve.com]
> Sent: Tuesday, February 11, 2003 1:22 PM
> To: Ant Users List; 'Ant Users List'; ant-dev@jakarta.apache.org
> Subject: RE: creating pl/sql package in sql task, only part of package
> lo aded
>
>
> Robert,
>
> Your PLSQL task resolved my issues.
>
> I was able to create a pl/sql package using your task in
> three separate
> ways that the sql task failed on. The package body is about
> 750 lines,
> just over 20kb of code. I created it from a file using the
> transaction
> task. I created it with the code in line within the plsql task and I
> created it with wrapped pl/sql code in line within the plsql task.
> (wrapping is an oracle mechanism that allows you to
> distribute your pl/sql
> code without revealing the source code).
>
> Many thanks for your contribution! I'll certainly be voting
> for it to be
> an enhancement request. I hope others do as well, without this
> enhancement, the limitations of the sql task in an Oracle
> environment are
> significant.
>
> cheers
>
> Tony
>
> At 12:31 PM 10/02/2003 -0800, Anderson, Rob H - VSCM wrote:
> >
> >Attached is the loadplsql task that I created by modifying
> the sql task. I
> >entered this in bugzilla as an enhancement request (Bug#
> 16945). If you
> >think this is worthy please go vote for it. Thanks,
> >
> >-Robert Anderson
> >
> >-----Original Message-----
> >From: Tony Obermeit [mailto:tonyob@compuserve.com]
> >Sent: Monday, February 10, 2003 11:27 AM
> >To: Ant Users List
> >Subject: Re: creating pl/sql package in sql task, only part
> of package
> >loaded
> >
> >
> >I've tried the other two suggestions, creating the package
> >specification/header with it's own sql task and creating the
> package body
> >with it's own sql task. I also tried the suggestion of
> loading the pl/sql
> >from a file and in both cases the same problem ocurred.
> I've run out of
> >ideas on using the sql task. Does anyone know where I can
> download this
> >extended task? Or have any other ideas of how to get pl/sql
> loading within
> >ant. The pl/sql code loads fine using sql *plus.
> >
> >thanks
> >
> >Tony
> >
> >At 07:59 AM 10/02/2003 -0500, you wrote:
> > >
> > >
> > >
> > >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 |
> > >| | <ynotob@yahoo.com|
> > >| | > |
> > >| | |
> > >| | 02/09/2003 06:53 |
> > >| | PM |
> > >| | Please respond to|
> > >| | "Ant Users List" |
> > >| | |
> > >|---------+---------------------------->
> > >
> > >
> >
> >-------------------------------------------------------------
> --------------
> >---------------------------------------------------|
> > > |
> > > |
> > > | To: Ant Users List
> <an...@jakarta.apache.org>, Martin
> > > <we...@laconiadatasystems.com> |
> > > | 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 <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
> > >
> >
> >---------------------------------------------------------------------
> > >To unsubscribe, e-mail: ant-user-unsubscribe@jakarta.apache.org
> > >For additional commands, e-mail: ant-user-help@jakarta.apache.org
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >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: user-unsubscribe@ant.apache.org
> > >For additional commands, e-mail: user-help@ant.apache.org
> >
> >
> >
> >
> >---------------------------------------------------------------------
> >To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
> >For additional commands, e-mail: user-help@ant.apache.org
> >
> >
> >---------------------------------------------------------------------
> >To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
> >For additional commands, e-mail: user-help@ant.apache.org
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
> For additional commands, e-mail: user-help@ant.apache.org
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscribe@ant.apache.org
> For additional commands, e-mail: dev-help@ant.apache.org
>
>