Re: OWA_UTIL.ident_arr and max size
Date: Tue, 29 Aug 2000 06:56:48 GMT
Message-ID: <8ofmr9$bos$1_at_nnrp1.deja.com>
Try:
in $ORAWEB_HOME/../cartx/plsql/admin edit the file pubutil.sql and change the line:
"type ident_arr ist table of varchar2(30) index by binary_integer"
to your choice i.e:
"type ident_arr ist table of varchar2(45) index by binary_integer"
run the script as i.e. OWA_DBA
Toni
In article <39A7E9F9.539C6AB3_at_sympatico.ca>,
Cathy Racicot <racicot_at_sympatico.ca> wrote:
>
> --------------320607D5431EC25174F20272
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> I'm using the Web Toolkit OWA_UTIL.ident_arr data type to pass
> multivalued parameters to another procedure.
>
> My problem is that the ident_arr is defined as VARCHAR2(30) and my
> parameters can be up to VARCHAR2(45), so when I try to pass a
parameter
> that is more than 30 chars long an error occurs.
> Is there any way I can change ident_arr to a VARCHAR2(45)?
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Tue Aug 29 2000 - 08:56:48 CEST