New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[plsql] Parse error with Cursor For Loop #681

Closed
jsotuyod opened this Issue Oct 23, 2017 · 3 comments

Comments

Projects
None yet
4 participants
@jsotuyod
Member

jsotuyod commented Oct 23, 2017

As per https://stackoverflow.com/questions/46883415/error-while-parsing-pkb-file

Description:

image

Code Sample demonstrating the issue:

        FOR sum_res IN (SELECT SUM(loss_reserve) loss_reserve,
                               SUM(expense_reserve) exp_reserve
                          FROM gicl_clm_reserve a, gicl_item_peril b
                         WHERE a.claim_id = b.claim_id
                           AND a.item_no  = b.item_no
                           AND a.peril_cd = b.peril_cd
                           AND a.claim_id = p_claim_id
                           AND (NVL(b.close_flag, 'AP') IN ('AP','CC','CP') OR 
                                NVL(b.close_flag2, 'AP') IN ('AP','CC','CP')))
        LOOP
           v_loss_res_amt  := sum_res.loss_reserve;
           v_exp_res_amt   := sum_res.exp_reserve;
        END LOOP;

Running PMD through: Any

@jsotuyod jsotuyod added the a:bug label Oct 23, 2017

@jabautista

This comment has been minimized.

jabautista commented Oct 24, 2017

Hi I'm the one who encountered this bug, do you need me to send you the pkb file so you can test it?

@jsotuyod

This comment has been minimized.

Member

jsotuyod commented Oct 24, 2017

@jabautista if you can (it's not sensitive) please do so. Thanks

@jabautista

This comment has been minimized.

jabautista commented Oct 24, 2017

I think it's okay. Here:
claim_status.zip

@adangel adangel changed the title from [plsql] Parse error during analysis to [plsql] Parse error with Cursor For Loop Jul 15, 2018

adangel added a commit to adangel/pmd that referenced this issue Jul 15, 2018

adangel added a commit to adangel/pmd that referenced this issue Jul 15, 2018

@adangel adangel added this to the 6.6.0 milestone Jul 15, 2018

@adangel adangel added the has:pr label Jul 15, 2018

adangel added a commit to adangel/pmd that referenced this issue Jul 20, 2018

adangel added a commit to adangel/pmd that referenced this issue Jul 20, 2018

@oowekyala oowekyala modified the milestones: 6.6.0, 6.7.0 Jul 28, 2018

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment