Split Data

[spicysudhi]

hi,

my table has a numberic ID column. I am writing a procedure to which I am passing a set of IDs separated by commas (procedure IN parameter is varchar2 type).

Need is to delete all the records from the table for the matching IDs.

Example:

Parameter value (name: varIds) = '1,2,3,4,5'
When I use below statement, it gives error coz the variable is string.

Delete from myTable where ID in (varIds);

--
is there any way to handle this except doing a split of the string and processing individual IDs?

thanks.

regards,
Sudhi

 

[oradba101]

Hi, Sudhi

Try

EXECUTE IMMEDIATE('Delete from myTable where ID in (varIds)') ;

Regards,



William Chadbourne
Oracle DBA

 

[LKBrwnDBA]

Actually it should be:

EXECUTE IMMEDIATE 'Delete from myTable where ID in ('||varIds||')';





----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb