Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: execute oracle stored procedure in 'SQL' job entry

  1. #1

    Default execute oracle stored procedure in 'SQL' job entry

    Hi everyone.

    I want to execute my oracle sp in SQL job entry.

    I tried like this ...

    'exec my_orcle_sp;'

    but,

    This code did not work.

    How can I execute my oracle store procedure in SQL job entry??

    thanks.


    Regards,
    YW Kim
    Last edited by warwithin; 10-20-2007 at 09:02 AM.

  2. #2
    Join Date
    Oct 2007
    Posts
    26

    Default Maybe a nameless PL/SQL block

    Maybe a nameless block like the following works:

    begin
    my_orcle_sp;
    end;

  3. #3
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    It has come up many times on this forum: we don't support dialects as found in:

    • Oracle SQL*Plus
    • mysql
    • psql
    • etc
    As such, if you really want to use these tools, for the time being until we allow you to execute these binaries, just launch it from a shell script.

    HTH,

    Matt

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.