This content has been marked as final. Show 2 replies
I had tried granting EXECUTE privileges on my packages and procedures to Portal user, as well as PORTAL_PUBLIC users. Additionally, I have also checked, the custom schema is already exposed as a provider.
However, it seems that the privileges didn't seep into the portal forms part fully perhaps - because some of the procedures can be called from the Dynamic Pages and they show up. That means the portal lightweight user is able to see them. However, while creating a form based on a procedure, when we look for the procedure to base upon, in that step, the pop-up window comes up and when I search for the procedures or packages in my custom schema here, no matches are returned.
Anyone has any clue please? Will appreciate some quick insights please.
I have met the same issue with oracle 10g XE and apex 4.2.2
I cannot build foms based on procedures becuase I can't find it stored in my schema procedures!
Anyone has a clue how to fix it?