This content has been marked as final. Show 6 replies
Ok, I found how it is done. Below are the steps. Thanks.
To run stored procedure in APEX via a webpage do the following
1) Login to the database as user SYS that store the APEX application, in my case MYAPP.
2) Locate the function called wwv.flow_epg_include_mod_local that belongs to user FLOWS_030100. I use TOAD so it is easy.
3) Modify the function.
a. Remarked the ‘return false’ statement.
b. Add the function name that need to be exposed to the web ‘MYAPP.PKG_AUTH.VERIFY_USER'.
CREATE OR REPLACE function FLOWS_030100.wwv_flow_epg_include_mod_local(
procedure_name in varchar2)
-- The next statement below (one Line) is remarked by Kueh 24/Dec/2008
return false; remove this statement when you modify this function
-- Administrator note: the procedure_name input parameter may be in the format:
-- If the expected input parameter is a procedure name only, the IN list code shown below
-- can be modified to itemize the expected procedure names. Otherwise you must parse the
-- procedure_name parameter and replace the simple code below with code that will evaluate
-- all of the cases listed above.
if upper(procedure_name) in (
Good Stuff!! Thanks
that's exactly what i need - it works fine :-)
Thanks and regards,
thanks al lot for the interesting topic and useful reply.
My question is how can I send parameter to stored procedure? or better
Can I send a parameter to stored procedure?
I am trying to execute a stored procedure using db link can any one help me with that .
v_statement := 'begin
DBA_BATCH.ACCOUNT_UNLOCK@DBNAME(''' || :INSTANCES || ''',''' || :USERNAME || ''');
EXECUTE IMMEDIATE v_statement;
Stop posting follow-ups to closed/old threads.
<li>Other users may ignore the thread as it appears to be closed
<li>Your assumption that the questions are related may be incorrect, leading to confusion about the nature of the problem and potential solutions.
<li>Watches on the thread may have expired, so the original participants may be unaware of the new post, or they may no longer be active on the forum
<li>APEX Phone Test
<li>You have no ability to mark posts as helpful or correct
Post your question as a new thread, including the following information:
<li>DB version and edition
<li>Web server architecture (EPG, OHS or APEX listener)
<li>Links to related posts and threads using the methods in the FAQ.
Your question has NOTHING to do with this thread.
And update your forum profile with a better handle than "862509".