mauleen2001 wrote:

> Hi Martijn Tonies,
>
> I had tried as u said but still it does not work.
> if i write in store-procedure
> Delete from container where fileid in ('FL005','FL006');
> it is deleted but i pass it as a input parameter it does not
> Delete from container where fileid in (:new1);
>
> Can anybody help me in this matter?
>

Martijn has already answered.

You cannot put 2 values ('FL005' and 'FL006') into 1 parameter (:new).
You cannot put 2 values ('FL005' and 'FL006') into 1 parameter (:new).
You cannot put 2 values ('FL005' and 'FL006') into 1 parameter (:new).

You might consider a "execute statement" thingy.


--
Aage J.