This discussion is archived
2 Replies Latest reply: Feb 6, 2013 6:22 AM by JacMa RSS

ORA-27473: argument 1 does not exist

JacMa Newbie
Currently Being Moderated
Hello

I've been trying to create a file_watcher to check for files arriving at the filesystem. But keep getting the error "ORA-27473: argument 1 does not exist ". I've searched forums but can't find an answer to get me on track.
Does anyone know why I get this error?

The examples I've been following are those provided by oracle and some from the web. All very simple and run, but mine does not.
The system I'm using is a Oracle prebuilt VM 'Database App Development VM', where the OS is Oracle Linux 5 and Oracle Database 11.2 EE.
An example is this: http://awads.net/wp/2011/03/29/did-you-know-about-file-watchers/

/JacMa
  • 1. Re: ORA-27473: argument 1 does not exist
    user503635 Explorer
    Currently Being Moderated
    Just wondering whether your enter this part correctly ?

    BEGIN
    2 DBMS_SCHEDULER.create_program (
    3 program_name => 'image_watcher_p',
    4 program_type => 'stored_procedure',
    5 program_action => 'process_image_files',
    6 number_of_arguments => 1,
    7 enabled => FALSE);
    8 DBMS_SCHEDULER.define_metadata_argument (
    9 program_name => 'image_watcher_p',
    10 metadata_attribute => 'event_message',
    11 argument_position => 1);
    12 DBMS_SCHEDULER.enable ('image_watcher_p');
    13 END;
    14 /
  • 2. Re: ORA-27473: argument 1 does not exist
    JacMa Newbie
    Currently Being Moderated
    Hi and thanks for your reply. And I am sorry for not replying until now.



    I dropped everything before I read your reply, but I think you are correct that there was something in my program that was wrong.

    I have created a simple program which just calls a procedure and this works. So I can build on this.



    Thanks

    JacMa

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points