[sqr-users] (SQR 5528) ORACLE OCIBindByName error 1036 in cursor 4:

[Savio J <frodo_rules@yahoo.com>]

Hi All,

***(SQR 5528) ORACLE OCIBindByName error 1036 in
cursor 4: ***

New to SQR and have been getting this error that does
not make sense coz I tried everything within my
limited knowledge :)
... If anyone has an idea as to what may be causing
then pls let me know...Thx in advance...
(I have included the entire procedure here for better
explaining this)

Amount_Array is an array that has been defined in the
Set-up routine and #RowId is the index used....

begin-select  on-error=Wrap-Up

YTD.DeptId
   let $YTD_DeptID  =  &YTD.DEPTID
YTD.ACCOUNT
   let $YTD_account =  &YTD.ACCOUNT
sum(YTD.POSTED_TOTAL_AMT)
   let $YTD_posted_total_amt =  &YTD.POSTED_TOTAL_AMT


!* Load array YTD buckets for PeopleSoft Accounts *!

 Evaluate $YTD.Account

    When =   299100
    Let Amount_Array.YTD299100(#RowId) =
$YTD_posted_total_amt
        Break                 !exit The Evaluate
Statement
    When =   299110
    Let Amount_Array.YTD299110(#RowId) =
$YTD_posted_total_amt
        Break                 !exit The Evaluate
Statement
    When =   299120
    Let Amount_Array.YTD299120(#RowId) =
$YTD_posted_total_amt
        Break                 !exit The Evaluate
Statement
    When =   299130
    Let Amount_Array.YTD299130(#RowId) =
$YTD_posted_total_amt
        Break                 !exit The Evaluate
Statement
    When =   299140
    Let Amount_Array.YTD299140(#RowId) =
$YTD_posted_total_amt
        Break                 !exit The Evaluate
Statement
    When =   299150
    Let Amount_Array.YTD299150(#RowId) =
$YTD_posted_total_amt
        Break                 !exit The Evaluate
Statement
    When-other
        Break                 !exit The Evaluate
Statement

 End-evaluate

FROM PS_ZGLT_PDRREF  YTD
 where  YTD.Business_Unit = $Business_Unit_WK
        and YTD.DeptID =    $DeptID_WK
        and YTD.Account IN(299100, 299110, 299120,
299130, 299140, 299150)
        and YTD.Accounting_Period between 0 and
$Accounting_Month
group by  YTD.DeptID, YTD.Account

end-select


__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!
http://webhosting.yahoo.com/ps/sb/

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users