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.
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
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!