1 person found this helpful
Go to your Application Details and check what your Parsing Schema is set to. If that's the correct schema, then that's the one you want to grant execute to, not to APEX_040100. You rarely need to grant directly to the APEX installation schema because your app runs under the rights of the Parsing Schema.
Hope this helps
INSERT INTO MDM_DATA.REF_CMR(STORE_CD)
(SELECT * FROM TABLE(MDM_DATA.UTIL.SPLIT(:P400_STORE_LIST,':')));
Thanks NoGot. It's the little things that often bite you in the rear. Under the heading of DOH!, adding the calling schema to the function call solved the problem.
Thanks Jorge. I know you are familiar with this application so I appreciate your response.