ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Antoine Levy-Lambert" <levylamb...@tiscali-dsl.de>
Subject Re: creating pl/sql package in sql task, only part of package lo aded
Date Wed, 12 Feb 2003 07:31:56 GMT
Hi Tony,
I think what you say (that the change should be made to the existing SQL
task, rather than creating a new task)
makes sense.
Maybe you should add your comments on this URL
http://nagoya.apache.org/bugzilla/show_bug.cgi?id=16945
This way, the ant committers will see your comments when they get to the
time when they can integrate Rob's proposal into ant.
Yours
Antoine
----- Original Message -----
From: "Tony Obermeit" <ynotob@yahoo.com>
To: "Ant Users List" <user@ant.apache.org>
Sent: Wednesday, February 12, 2003 3:06 AM
Subject: RE: creating pl/sql package in sql task, only part of package lo
aded


> Hi Rob,
>
> Thanks for your efforts in resolving this.  My
> preference would be for these changes to be made to
> the sql task rather than implmenting a new task.
> Possibly a new attribute to the sql task that states
> the code is a "block" or something like that.
> However, because I'm new to the ant user list I will
> simply vote on this being a great enhancement and let
> the powers that be figure out if they want it to go
> into the base sql task or have a new task.  This issue
> must apply to other databases that allow stored
> procedure creation within the database.
>
> I'm really relieved that your code worked because my
> application deployment strategy depended on being able
> to create all my datbase objects using ant.  It means
> I can distribute my application in pure jave, no
> oracle dependencies on the platform that my
> application is installed on.
>
> cheers
>
> Tony
>
> --- "Anderson, Rob  H - VSCM"
> <Anderson.Rob@vectorscm.com> wrote:
> >
> > 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
> > <ant-user@jakarta.apache.org>, Martin
> > > > <webmaster@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 <mgainty@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"
> > > > > <levylambert@tiscali-dsl.de>
> > > > > To: "Ant Users List"
> > <ant-user@jakarta.apache.org>;
> > > > > <tonyob@compuserve.com>
> > > > > Sent: Sunday, February 09, 2003 7:15 PM
> > > > > Subject: Re: creating pl/sql package in sql
> > task,
> >
> === message truncated ===
>
>
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Shopping - Send Flowers for Valentine's Day
> http://shopping.yahoo.com
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
> For additional commands, e-mail: user-help@ant.apache.org
>


Mime
View raw message