creating pl/sql package in sql task, only part of package
loaded | creating pl/sql package in sql task, only part of package
loaded 2003-02-09 - By 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>
|
|
 |
