in cloud, a package created by PL/SQL Developer, how to make the procedure be available for projection custom action method and database task?
Solved
in cloud, a package created by PL/SQL Developer, how to make the procedure be available for projection custom action method and database task?
Best answer by Charana Udugama
Hi
Try this method.
You can export an existing Database Task. Then you just modify the exported XML file to have “YOUR_PACKAGE_API.YOUR_PROCEDURE” as the method and the necessary parameters. Then you can import the XML file back to Cloud. Then you have a new database task in the system which calls your new procedure.
Here is the example for “EVENT_SYS.EVENT_EXECUTE”. Which is a core method not available for DB Tasks. I’ve imported it like this, and it works just fine.
+12Hi
Try this method.
You can export an existing Database Task. Then you just modify the exported XML file to have “YOUR_PACKAGE_API.YOUR_PROCEDURE” as the method and the necessary parameters. Then you can import the XML file back to Cloud. Then you have a new database task in the system which calls your new procedure.
Here is the example for “EVENT_SYS.EVENT_EXECUTE”. Which is a core method not available for DB Tasks. I’ve imported it like this, and it works just fine.
Hi Charana, thanks so much, I follow you steps and it works fine. whether the setup be removed/changed when new release update?
+12IFS Cloud's release update process is designed to ensure that customizations and configurations are preserved.
I’m not sure about this. I’ll check internally and let you know.
If this solved your initial problem, please mark it as the solution.
Best Regards,
Charana
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.