Pass cursor iteration as parameter to PL/SQL procedure or function
posted 5 years ago
Hi to all, i have the next situation:
I have a package with 2 procedures, procA and procB. Inside procA i call several times to procB. Inside procA i iterate over a cursor defined in the package, not in the procedure. The cursor is a query from various tables. I need to pass to procB the entire "row" of my cursor when i'm iterating because cursor query columns are a lot and i don't want to declare all those colums as parameters in procB. I've tried using REF CURSOR and RECORD but probably i do something wrong because it doesn't work.
Here's the code of my package:
What's wrong in my ref cursor?
Wanna grow? Learn, live, love people and enjoy life