Thanks for the reply. Sorry I am new to Oracle..
Trying to execute the procedure
I give this

execute PakageName.ProcedureName('Name_to_be_searched', dnOutCursor);

I get invalid SQL error

How do initialize the output cursor here and execute it?

THanks Again

orauser73