I have a question about custom events in Cloud version 25R2. At present I am using 25R1 and I can execute Online SQL in an custom event action. As I understand it in 25R2 it will not be possible to execute Online SQL (e.g. “insert into [table name] “) but it will be possible to call a procedure in a custom package (and pass in a value to it).
E.g. the procedure in the package I am calling in the screencap below will work in 25R2?
Thank you.
Best answer by SimonTestard
25R2 right now definitely allows online SQL actions which is just a PL/SQL block anyways, so what you’re suggesting here would absolutely work, assuming of course it doesn’t mutate the source table the oracle trigger is based on.
+8Hi John,
You should be inserting data direct into tables in any version of IFS as this does not respect the IFS business logic.
You should use the related API such as CUSTOMER_ORDER_API.new__
This enforces business logic and correctly structures the data.
Hi John,
You should be inserting data direct into tables in any version of IFS as this does not respect the IFS business logic.
You should use the related API such as CUSTOMER_ORDER_API.new__
This enforces business logic and correctly structures the data.
Hi Mike thanks for the reply. Yes I know it is bad practise to insert directly into tables in IFS, it is better to use an API call. My question was related to Cloud 25R2; Will an API call in a custom event (like the one I have underlined in red text in my screen cap) work in 25R2?
25R2 right now definitely allows online SQL actions which is just a PL/SQL block anyways, so what you’re suggesting here would absolutely work, assuming of course it doesn’t mutate the source table the oracle trigger is based on.
25R2 right now definitely allows online SQL actions which is just a PL/SQL block anyways, so what you’re suggesting here would absolutely work, assuming of course it doesn’t mutate the source table the oracle trigger is based on.
Perfect thank you
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
