You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ant.apache.org by Tony Obermeit <yn...@yahoo.com> on 2003/02/12 03:06:08 UTC
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"
<An...@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
> <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,
>
=== message truncated ===
__________________________________________________
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day
http://shopping.yahoo.com
Re: creating pl/sql package in sql task, only part of package lo aded
Posted by Antoine Levy-Lambert <le...@tiscali-dsl.de>.
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" <yn...@yahoo.com>
To: "Ant Users List" <us...@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"
> <An...@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
> > <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,
> >
> === 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
>