The DBD::Oracle docs cover how to call stored procedures.
However, if you have stored procedures that generate web pages via the
mod_plsql web toolkit functions/procedures in the htp/htf packages, you should
be using the mod_plsql gateway to execute them. Those functions/procedures
are designed to be called from the mod_plsql gateway and they directly interact
with apache. Outside of that context, I would be suprised if they can be used
directly.
I am not sure what value any of the owa_util procedures would have to you in a
mod_perl context. Since mod_perl is taking the output of perl's
functions/procedures and sending them to the apache server to build the http
header and content, the typical mod_plsql web toolkit stuff won't work, unless
you can capture its output in perl, and than send it back out to apache.
I don't know if/how you could capture the output of htp/htf or other owa_util
functions via perl unless it was LWP to a mod_plsql gateway. A call to
owa_util.show_source is a way to output the contents of a procedure that uses
the mod_plsql web toolvia via dbms_output (i think) through sql*plus without
mod_plsql gateway, so maybe this could be used to convert the traditional
output of mod_plsql functions into dbms_output stuff you could capture it in
perl.
I would question such an approach, since show_source is really designed for
debugging mod_plsql toolkit functions via sql*plus.
Your interaction with pl/sql from mod_perl I would think would typically be to
pass inputs to procedures to return cursors/result sets to your perl client or
to do data input. using pl/sql to output stuff to the browser overlaps with
all the mod_perl modules for interaction with apache.
The error you are getting is a generic error described well on metalink, so
unless you provide the perl code that executes the procedure, the inputs to the
procedure, and the source of the proc, we probably won't be able to help that
much.
any corrections are welcome. I hope this helps.
Job
Kevin Moore <[EMAIL PROTECTED]> wrote:
All,
I've got Apache v2.x, Oracle 9i, running on Red Hat linux 9, mod_perl,
and DBI installed and working. I'd like to be able to execute Oracle
stored procedures. Is anyone doing this without the mod_plsql plugin? If
so, would you be wlling to share tips for making this work.
I've already got stored procedures and am connecting to the database but
am seeing the following errors.
DBD::Oracle::db do failed ORA-06502.: PL/SQL: numeric or value error
ORA-06502: at "SYS.OWA_UTIL", line 323
I really need to know if there is something Apche needs to display pages
generated fro stored procedures. Any help will be appreciated.
thanks.
Kevin
---------------------------------
Discover Yahoo!
Get on-the-go sports scores, stock quotes, news & more. Check it out!
