Question
Calling pl/sql procedures (Oracle)
a) A question similar to the "PostgreSQL Scirpt (.SQL)" one: is there a way of calling Oracle PL/SQL procedures inside a FMW workflow? b) How can I call a DB procedure after the writer is completed, as a post-process item in the FMW workflow? For example, recreating the indexes after writing data.
a) You can use a SQLExecutor on an Oracle database, spatial or non-spatial.
b) On a Oracle writer you can set a "SQL Statement To Execute Before/After Translation" as (advanced) parameter.
Hi,
you can use an SQLExecutor to call PL/SQL procedures in your Workspace flow. Each feature entering the transformer will trigger the procedure once, optionally with attributes from the feature as parameters.
For question b), you can use the workspace shutdown script. In the Navigator: Workspace Parameters / Advanced / Shutdown Python script.
Hope this helps.
David
Thank you!!
I did not know about the Shutdown scripts nor the SQL Statement to execute before/after translation. It will be very useful for me!
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.