Re: Error

Scott Hamlin wrote:

> I am having a problem when trying to send a PL/SQL procedure inside a
> package. The value is a varchar2 and can be a single numeric value or a
> comma delimited value.
>
> <snipped>

You can stop right here. What you are trying to do can not be done as you are trying to do it.

Go to http://tahiti.oracle.com and look up "Native Dynamic SQL." You will need to create your SQL statements by concatenating the pieces into a VARCHAR2 and executing it with NDS.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)