Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to execute remote stored procedure from apex process

Robin Hochteil-OracleApr 28 2017 — edited Apr 29 2017

Hi. I've created a stored procedure in my oracle database. I want to execute that stored procedure from an APEX process. Can this be done. If so, how?

I am getting ORA-00900: invalid SQL statement when I try to execute this....

                execute oracle_username.APEX_LOAD_TEMPLATE@xxx;

Where xxx is the remote link back to my oracle database in user schema "oracle_username"

Thanks,

Robin
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 27 2017
Added on Apr 28 2017
#apex-discussions
6 comments
1,338 views