creating pl/sql package in sql task, only part of package loaded

[Tony Obermeit]

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]