Solved

IAL returning error when calling API function

  • 23 March 2023
  • 3 replies
  • 170 views
J
Rank
Badge +2
  • JacJL
  • Do Gooder (Customer)
  • 3 replies

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.

icon

Best answer by Jacek Borski 24 March 2023, 11:52

View original

3 replies

H
Rank
Userlevel 3
Badge +8

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. 

J
Rank
Badge +1

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

J
Rank
Badge +2

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

Reply


Terms & ConditionsCookie settings