Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Pass cursor iteration as parameter to PL/SQL procedure or function

 
Oscar Calderon
Ranch Hand
Posts: 32
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?

Regards.
 
Gene Hilpert
Ranch Hand
Posts: 51
Eclipse IDE Hibernate Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
On line 14 I think it should be = vPago.c2 not =rVarPago.c2 because rVarPago is a type
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic