Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Passing array values into pl/sql procedure via a URL
I thought I had this all sorted out.....
Created a type:
create type vc2000_array as table of varchar2(2000) /
Then I defined a procedure thus:
procedure campaign_form
(p_web_site_id in number, p_camp_code in varchar2 default null, p_style_id in number default null, p_title in varchar2 default null, p_name in vc2000_array default vc2000_array(), p_value in vc2000_array default vc2000_array());
This is to be executed via web browser through mod_plsql
If I call it like this:
<hostname etc.>/campaign_form?p_web_site_id=304&p_camp_code=XX
It executes.
But if it is called like this
<hostname etc.>/campaign_form?p_web_site_id=304
&p_camp_code=XX&p_name=nam1
It fails with an error in the log file
[Wed Apr 26 18:38:55 2006] [error] mod_plsql: /plql/campaign_form HTTP-
404 ORA-06550: line 10, column 2:
PLS-00306: wrong number or types of arguments in call to 'CAMPAIGN_FORM'
ORA-06550: line 10, column 2:
PL/SQL: Statement ignored
In I had thought I would be able to pass in multiple values of p_name in
the URL like:
&p_name=name1&p_name=name2 etc
but find I cannot even pass just one in :(
Any ideas anyone?
-- jeremy We use Oracle 9iR2 on Solaris 8 with the Oracle HTTP Server and mod_plsqlReceived on Wed Apr 26 2006 - 13:03:41 CDT
![]() |
![]() |