I have painstakingly created a couple of plsql db queries and saved
them as *.sql files.    Is there a simple way to create a package out
of these two plsql queries or do I need to re-write them as stored
procedures/functions?    I'm dreading having to translate these into
sprocs/functions because they contain cursors that i don't yet know
how to implement.

Thanks.

Judging by the code in your other post, you can leave most of the code
as is, just changing 'DECLARE' into the 'CREATE PROCEDURE...'
statement.

-----------------------------------------------Reply-----------------------------------------------