+4Hello,
I have created an API package with a function to return specific data. When I call this function in my IAL, I am returned with error “table or view does not exist”
Some things to note:
I am unsure of what would be causing this error. Any help is appreciated.
Best answer by Jacek Borski
Are you sure that permissions to this function were granted to IFSINFO?
You can do it using with this procedure (at least in IFS8):
Database_SYS.Grant_All_Objects_Ial('IFSINFO');
In my experience IAL’s run under userspace IFSINFO, so if you we’re calling an API you’ve written under IFSAPP, you might be better calling the API function explicity i.e. ifsapp.your_api.function.
+1Are you sure that permissions to this function were granted to IFSINFO?
You can do it using with this procedure (at least in IFS8):
Database_SYS.Grant_All_Objects_Ial('IFSINFO');
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
