Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> dynamic pl/sql
hi ng,
is there a way to pass a list of items into a package or procedure?
for example...
i want to return some field where name = 'Mark', 'John', 'Mike' -- this list
will NOT contain a set number of items
create procedure test
vList varchar2
as
Select *
From table
Where name is in vList (can i use instr and say -- Where instr(vList,
name) > 0)
can pl/sql be built in the procedure and be run?
declare vSQL varchar2
vSQL = "Select * from table"
execute vSQL
thanks in advance,
MarkD
Received on Fri Oct 06 2006 - 16:12:09 CDT
![]() |
![]() |