I created a procedure using the SQL Command Proccessor that contains HTP calls, and granted execute on this procedure to public. Now I want to call this procedure in a popup window but I am not sure what schema I use to call the procedure. Normally (if I built this using SQL*Plus and Apache), I would call a procedure like this http://www.foo.com/pls/htmldb/user_schema.CAL_REP?p_event_id=1. However, this does not work with the listed User schema or the flow's user. Is there a way to do this sort of thing?
1 procedure "CAL_REP" (p_event_id IN NUMBER)
2 is
3
4 enotes varchar2(250);
5
6
7 begin
8 htp.p('<html><body><table>');
9
10 EXECUTE IMMEDIATE 'select EVENT_NOTES from FLOWS_010308.PTSA_SCH_EVENTS where ID = p_event_id'
11 into enotes;
12
13 htp.p('<tr>');
14 htp.p('<td>'||enotes||'</td>');
15 htp.p('</tr>');
16 htp.p('</table></body></html>');
17 end;