3 Replies Latest reply: Apr 10, 2014 1:19 AM by Phanikanth RSS

    Procedure

    MyOAF

      I created a simple procedure on ODI12c and the below is the statements used in the procedure.

       

      BEGIN

      DELETE  TRG.PGMSTAT_STAFF_STG;

      COMMIT;

       

      When I run the procedure, it gets completed successfully but not deleting any records. I checked the grant privilege , WORK schema has ALL privileges on the table. I just wondering if there is a way to return a value when its successfully deletes or fails for some reason. Also, how to check if the delete statement is getting executed properly?

        • 1. Re: Procedure
          MyOAF

          Forget to mention the database , both target and source is Oracle.

          • 2. Re: Procedure
            SaranPantangi

            Hi,

             

            In the odi log you can find error message. Looks like there is syntax error with the query you mentioned.

            FROM keyword is missing here:

            DELETE  FROM TRG.PGMSTAT_STAFF_STG;


            Thank you!

            Saran

            • 3. Re: Procedure
              Phanikanth

              Hi

               

              As per saranpatangi, yoou forgetten From key work from delete statement and hope you checked the ignore error option on ODI procedure so you got warning message for procedure step and session got green color (indicate it is successfully executed), please un-check the ignore error  option on ODi procedure and run the procedure and you will get exact error message on operator

               

              Regards,

              Phanikanth