Forum Stats

  • 3,875,563 Users
  • 2,266,946 Discussions
  • 7,912,254 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,559 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.