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]