Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Can I execute begin for loop in Execute sql step?

  1. #1

    Default Can I execute begin for loop in Execute sql step?

    Begin

    for .....

    loop

    Update statement which update multiple rows.

    end loop;

    end;

    --------------------------------------------------------------

    Getting error:

    ERROR (version 5.4.0.1-130, build 1 from 2015-06-14_12-34-55 by buildguy) : An error occurred executing this job entry :
    2015/12/17 13:06:51 - SQL - Couldn't execute SQL: BEGIN
    .
    .
    .
    .
    ORA-06550: line 7, column 95:
    PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:


    * & = - + ; < / > at in is mod remainder not rem return




    Thanks,
    Nishank

  2. #2
    Join Date
    Apr 2008
    Posts
    1,771

    Default

    I think you need to use option "execute for each row".
    -- Mick --

  3. #3

    Default

    Thanks for reply Mike.

    I will try this.


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.