Hello.
I need to make a new db task, calling a custom procedure from a custom package, this procedure has no parameter.
On the new db task page, I click on the method button. What’s the path to call my custom procedure from my custom package?
Thanks
Best answer by Manulak
View original
+2
Did you check under IFS Custom Created Objects?
+8
Creating the database task correctly
Once you’ve created the custom package procedure, make sure to refresh the dictionary cache. Otherwise your procedure will not be visible.
On the screen New Database Task make sure to first select the component which your custom package was deployed against. Then, selecting the method using the Method Name LOV will be easy as it’s then filtered by the selected component.
Click on the Select Method link and get the LOV > select the LU and then you should see the corresponding procedure you’ve created. Just, select it.
In general, this is enough as your procedure has no parameters.
Calling the database task
Once the database task is created, it either needs a scheduled task which refers it, or a trigger point (maybe via an event) which executes the database task directly via PLSQL logic.
App_Message_Processing_API.Run_Application_Server_Task(application_message_id_, one_time_task_)
Hope this helps
There is no IFS Custom Created objects entry
Didn’t you mean IFS Custom objects ?
Anyway, I didn’t find any custom package :
+2
There is no IFS Custom Created objects entry
Didn’t you mean IFS Custom objects ?
Anyway, I didn’t find any custom package :
What module is your package deployed to?
in my case, it’s CONFIG
+8
As I previously mentioned, your procedure is visible under the component and module your package was deployed against.
In your case, search the method under IFSApplications > IFS Customer runtime configuration compoment > PackageSpe > MySociety_API
Sorry Manulak, when I published my 1st reply, I didn’t see your post.
The path you are showing is indeed the right one.
Many thanks
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
