SQL & PL/SQL

Hi All,
Can we declare a cursor inside a begin/end block. If we can, please let me know how. I want to declare a cursor where it will return value based on user parameters. User will be entering like username(for example), we have to retrive the ID of the username and we have to pass it to cursor. For this we have written a query to fetch id into a variable in other begin/end block and we have pass this variable into cursor. Is this possible.



Thanks and Regards,
Mahesh