Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Get error of oracle stored procedure

  1. #1
    Join Date
    Feb 2007
    Posts
    3

    Default Get error of oracle stored procedure

    I have been invoking a stored proc in oracle with an sql job entry, then a error ocurred into the sp (ORA-01403: no se han encontrado datos), but the output of sql entry is true. How I do for get false in the output?


    Thanks

    Regards
    Pablo

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    Getting no data may not be an error... what about throwing an exception in your PL-SQL?

    Regards,
    Sven

  3. #3
    Join Date
    Feb 2007
    Posts
    3

    Default

    Hi Sven, I agree with you, but, when I use "Call DB Procedure" step in one transformation, then the output for this step is "error". I hope the same behaviour in the SQL for jobs.

    I think that any "internal error" in stored procedures without capture of exception should generate error in the sql entry for jobs.

    Thanks

  4. #4
    Join Date
    May 2006
    Posts
    4,882

    Default

    SQL job entry is not really to be used for calling PL-SQL, maybe you can raise a small JIRA to see whether the current behaviour of SQL job entry can be modified.

    Regards,
    Sven

  5. #5
    Join Date
    Feb 2007
    Posts
    3

    Default

    OK Sven,

    Thanks for your response.


    Regards
    Pablo

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.