Forum Stats

  • 3,816,891 Users
  • 2,259,246 Discussions


How to dynamically get proc/func params?

JackK Member Posts: 701 Bronze Badge
edited Feb 7, 2021 4:22PM in SQL & PL/SQL

Hi All!

I would like to refer to my old question:

Is this possible nowadays? I am now using Oracle 19c.

Many thanks.


  • Paulzip
    Paulzip Member Posts: 8,677 Blue Diamond

    Your requirement of


    Is flawed, as the scope of the proc1's params is only local to Proc1 unless you pass them to another proc explicitly. If you hand off to another procedure, just by name, Proc1's parameters will be pushed onto the stack, so are no longer available to the ac_params proc.

    You'd either have to handle the params locally within Proc1, which means you couldn't easily refactor a one solution fits all, or you'd have to pass the list of params to ac_params, which you don't want to do.