hi
while creating an application role i need to pass a package name
eg.
create role myrole identified using package1
what statements should i write in this package .
i also want to view all the procedures and packages in my database how would i pass a query.
thanks