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. -- //www.freelists.org/webpage/oracle-l