Wow, fast service :)
If you want to add Oracle support to the DataSQL task, the following
patch works for us and our Oracle 8i server.
*** src/templates/sql/load/oracle/row.vm Wed Dec 31 14:00:00 1969
--- src/templates/sql/load/oracle/row.vm Wed Dec 5 11:30:06 2001
***************
*** 0 ****
--- 1,4 ----
+ INSERT INTO $row.Table.Name (##
+ #set ($comma="")#foreach($col in
$row.ColumnValues)$comma${col.Column.Name}#set($comma=",")#end)
+ VALUES (#set ($comma="")#foreach($col in
$row.ColumnValues)$comma${generator.parse("sql/load/oracle/val.vm", "",
"column", $col)}#set ($comma=",")#end);
+
*** src/templates/sql/load/oracle/val.vm Wed Dec 31 14:00:00 1969
--- src/templates/sql/load/oracle/val.vm Wed Dec 5 11:05:26 2001
***************
*** 0 ****
--- 1 ----
+
#if($column.Column.TorqueType=="VARCHAR")'$column.Value'#else$column.Value#e
nd
Dan
--
Dan Everton
EngNET Coordinator
Central Engineering, Boeing Australia Limited
Phone: +61 07 3306 3288 -- Email: [EMAIL PROTECTED]
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
