community.borland.com

Article #25436: invalid request BLR at offset 13369

Problem:
 Getting the following error while trying to compile a
         stored procedure script..
               "invalid request BLR at offset 13369
                -context not defined (BLR error)  " 

Solution:
 Customer had written a fairly lengthy stored procedure,
      that essentially transfers selected data from say, table A,
      to table B, based on a date input parameter.

        It was noticed that he had declared a local variable in the
      stored procedure to store the sum() of a certain field value in
      Table A.  This value was used for every select (from table A) and     
      update (into table B) statement pair..  This variable was
      declared as ..
            "declare variable flt_temp decimal (10,2)"

        However, the field in the Table A, whose value was being
      summed... was declared as...
            CREATE TABLE ACP_GLDATA (ACCT INTEGER,
                                     OFFICE_NUMBER INTEGER,
                                     FAP DATE,
                                     ACCT_TOTAL_FAP NUMERIC(15, 2));

        In the stored procedure there were a series of select-update
      statement pairs that were like this...
             select sum (acct_total_fap)
             from acp_gldata
             where fap = :dte_fap
             and office_number = :int_office_number
             and acct = 1020
             into :flt_temp;

             update acp_office_rollup
             set fuel_revenue = :flt_temp
            where fap = :dte_fap   

Changed the local variable in the stored procedure script
       to "decimal(15,2)" to make it same as that of the corresponding
       value in  Table A.
          By doing this the error went away..
       However, based on the size of the stored procedure, there might
       be other reasons for this error as well. 

Last Modified: 26-OCT-00