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]
