2 Replies Latest reply on Mar 26, 2014 1:07 PM by Kanishkaa

    get_attribute procedure

    Kanishkaa

      Hi All, 

           In my application I have already used dbms_scheduler.set_attribute procedure. Now am trying to implement get_attribute procedure. But am facing a lot of issues in it.

       

      My procedure is,

       

      CREATE OR REPLACE procedure dna_get_attribute ( v_owner in varchar2 , v_objname in varchar2, v_attr in varchar2 , v_value in varchar2)

      IS
      obj_name varchar2(100);
      BEGIN
      obj_name := v_owner || '.' || v_objname;
        DBMS_SCHEDULER.GET_ATTRIBUTE (
         name           =>   obj_name,
         attribute      =>   v_attr,
         value          =>   v_value);


      END dna_get_attribute;

       

      Its throwing an error of SQL statement ignored.

       

      I dono where am going wrong. Here name , attribute are input values and value is the output value which I needed finally.

       

      owner -> owner of the job/chain

      v_objname  -> job, chain etc

      v_attr -> comments, job_type, etc

       

      Pls help me out.

       

      Thanks in advance

       

      Kanishkaa