Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

form 6i error - error 103 encountered the symbol case

SANPATDec 17 2015 — edited Dec 17 2015

I am using Form 6i , in the Program I had given the following query where I am getting a error message . kindly see below query and screenshot

cursor c3 is select canworkorder.workorderno , sum (case when canptn.fgstat is null then canptn.ptnqty end) intqty

, sum (case when canptn.fgstat is not null then canptn.ptnqty end) ptnqty

 , min (canptn.ons) ons    from canworkorder, canptn  where canworkorder.pendingqty > 0

and (canworkorder.workorderno = canptn.workorderno) and canworkorder.pendingqty > 0

group by canworkorder.workorderno;

sandy

This post has been answered by Manu. on Dec 17 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 14 2016

Added on Dec 17 2015

#form, #forms, #moved-from-devops

3 comments

1,046 views