Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Variable where clause
Hi all,=20
I have to write pl/sql proc that will return cursor.=20
Input parameters could be 1) map, 2) map, map_division or 3) map,
map_division, map_subdivision.
I don't want to write separate procedures for each input parameter combinat=
ion.=20
Input parameters will be matched against portions of 19 char string,=20
for example substr(roll, 4, 3) =3D map
substr(roll, 7, 3) =3D map_division
How do I do this ?=20
Regards, Ranko.
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jun 14 2005 - 18:06:15 CDT
![]() |
![]() |