Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Passing array values into pl/sql procedure via a URL

Passing array values into pl/sql procedure via a URL

From: Jeremy <jeremy0505_at_gmail.com>
Date: Wed, 26 Apr 2006 19:03:41 +0100
Message-ID: <MPG.1eb9c64bcc78941398a19c@news.individual.net>

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_plsql
Received on Wed Apr 26 2006 - 13:03:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US