1

I have created a program with dbms_scheduler :

DBMS_SCHEDULER.CREATE_PROGRAM (
       program_name=>xxx ,
       program_type=>xxx,
       program_action=>xxx,
       number_of_arguments=>xxx ,
       enabled=>xxx ,
       comments=>xxx );

Can you please tell how can i get the arguments/parameters of a created program in Oracle or if you have any system table to suggest

PS : i already checked the table: ALL_ARGUMENTS (the program doesn't even figure in this table list but it figures in the table ALL_OBJECTS)

Thank u for helping !

MT0
  • 143,790
  • 11
  • 59
  • 117
Mohamedmehdi Ellouze
  • 7
  • 4

1 Answers1

0

You might be looking for the view dba_scheduler_program_args

doberkofler
  • 9,511
  • 18
  • 74
  • 126
  • Thank you ! i just changed the "dba" by "user" to get "user_scheduler_program_args" because "dba_scheduler_program_args" returns the error : ORA-00942: table or view does not exist – Mohamedmehdi Ellouze Jun 09 '22 at 08:16