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] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]