I created a custom function within PL/SQL to calculate the number of business days between two dates, based on a particular IFS calendar. I’d like to use this in an IAL Object, but I’m getting an error that it is not-defined. How do I appropriately define it so the IAL Object will deploy without error? We are on IE 10.
Hi
Have you used the &AO.. prefix before the API call when writing the IAL object?
Also use an alias for the expression.
Eg -:
IAL objects are created under IFSINFO (IAL Owner) user and the APIs are under IFSAPP (app owner) user. So to use objects under IFSAPP user we have to specify the user/schema before object name.
+2
Yes, I am, the part in question is the custom function. If I have a custom function declared, must I have written an API for that function?
I thought you defined that in one of the existing entity .plsql files. If you do that it will be automatically a part of that relevant entity API.
In IAL we can write a view and it supports what a standard view supports in Oracle.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.