Joined: 13 Feb 2004 Posts: 551 Location: Bangalore
thanks umey for ur response ..... but here the above cursor was just an example .....actually the where clause contains 6 keys ..and in total i shud declare 18 cursors which is goin to give a huge bind ....
neways i figured out a way for this ...
u can declare the cursor as below ...
declare c1 cursor for
( name = :ws-name or name = ' ')
and ( empno =:ws-empno or empno = ' ' )
and ( dept = :ws-dept or dept = ' ')