Forum Stats

  • 3,854,938 Users
  • 2,264,435 Discussions
  • 7,905,839 Comments

Discussions

Ref Cursor over DB Link

Nimish Garg
Nimish Garg Member Posts: 3,185 Gold Trophy
edited Jan 11, 2016 6:03PM in Database Ideas - Ideas

Currently We cannot pass refcursor over db link. I think it would be good to have this feature, if we can pass a refcuror over a db link. It will simplify the current process which we use as work-around

Nimish GargBPeaslandDBAtop.gunMeddyOzgur Umut VurgunsensoftulohmannSven W.
8 votes

Active · Last Updated

Comments

  • Sven W.
    Sven W. Member Posts: 10,551 Gold Crown

    Why would you prefer a refcursor over a db link instead of a direct select (maybe based upon a pipepline table function?).

    Refcursors are often used to establish an interface for a java or .net application. I don't see (yet) how this helps for direct database logic.