I have created a PLSQLLoad task (modified the SQLExec.java) to address this issue. Give it a try. It seems to work well for me.
-Robert Anderson -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 11:22 AM To: [EMAIL PROTECTED] Subject: SQL target commits code as single line in oracle Does anyone know how to get the sql tag to create objects in Oracle with multiple lines? The target seems to read in entire files ignoring the line breaks. I am running ant on Unix against Oracle 8, when I run the targets and use toad or sqlplus to view the objects they are on one line. Michael Medwith Flagstar Bank Wholesale Web Development Team 284-312-5959 [EMAIL PROTECTED] This e-mail may contain data that is confidential, proprietary or "non-public personal information", as that term is defined in the Gramm-Leach-Bliley Act (collectively, "Confidential Information"). The Confidential Information is disclosed conditioned upon your agreement that you will treat it confidentially and in accordance with applicable law, ensure that such data isn't used or disclosed except for the limited purpose for which it's being provided and will notify and cooperate with us regarding any requested or unauthorized disclosure or use of any Confidential Information. By accepting and reviewing the Confidential Information you agree to indemnify us against any losses or expenses, including attorney's fees that we may incur as a result of any unauthorized use or disclosure of this data due to your acts or omissions. If a party other than the intended recipient receives this e-mail, you are requested to instantly notify us of the erroneous delivery and return to us all data so delivered. -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
PLSQLLoad.java
Description: Binary data
-- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>