Skip to Main Content
  • Questions
  • Calling a linked procedure with out cursor parameter in another procedure

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, saeedeh.

Asked: October 18, 2017 - 2:01 pm UTC

Last updated: October 19, 2017 - 1:52 am UTC

Version: 11.1

Viewed 1000+ times

You Asked

Hello,
I need to have a procedure with out cursor parameter which I am calling it via a db link, inside a procedure,
how can I implement that?
procedure Myouterprocedure(...,
my_out_cursor out cursor,
...) is
...
Myinnerprocedure@db_link(..,
my_out_cursor,
...);

... ;
Thank you

and Connor said...


Is this answer out of date? If it is, please let us know via a Comment

More to Explore

PL/SQL demos

Check out more PL/SQL tutorials on our LiveSQL tool.

PL/SQL docs

PL/SQL reference manual from the Oracle documentation library