Below is the SQL package which is going to be a part of a script. In this package the cursor used is fetching sufficient records as required, but not working when I am incorporating in this package. On changing the cursor while putting less where conditions, it works just fine. But somehow this is the correct cursor.

I want to use this code in a package:

I need to use this code in a PL/SQL package:

I’m encountering an issue with the DBMS_PICKLER package in Oracle. After creating a custom type