Hi
I'm trying to execute an Oracle procedure before (and after) a
translation in the workbench.
I've tried adding entries in the BEGIN_SQL array in the header block,
and also using the SQLExecutor transformer. I can get simple single
SQL statements to run (DELETE/DROP/CREATE statements),but i can't do is
execute a procedure.
Each time I try this I get an error similar to this one:
Error posing SQL query `exec nsg.usp_fme_import_begin_sql (1)' to
database connection: `Execution of statement `exec
nsg.usp_fme_import_begin_sql (1)' did not succeed; error was `ORA-
00900: invalid SQL statement
I've tried "begin nsg.usp_fme_import_begin_sql (1); end;" but it just
freezes the translation. Other SQL varients don't work either...
The `exec nsg.usp_fme_import_begin_sql (1)' statemnt runs fine in
sqlplus so it's not a SQL error as such.
Can anyone tell me what the correct syntax is in FME to execute a
procedure? And if it's not possible can someone suggest how I can test
for the existence of an index and drop it if it does exist using the
BEGIN_SQL array or SQLExecutor transformer.
cheers
-bill-
Get the maximum benefit from your FME, FME Objects, or SpatialDirect via our
Professional Services team. Visit www.safe.com/services for details.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/fme/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
