Skip to main content

Hello,

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 using &AO..
  • Permissions have been granted
  • Cache has been refreshed
  • Function runs correctly in oracle
  • Function works in Lobby element
  • Function works in Quick report 
  • Function returns one value

I am unsure of what would be causing this error. Any help is appreciated.

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. 

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');

@Jacek Borski  Looks like this was the issue, runs fine now. Thank you!

Reply


Terms & ConditionsCookie settings