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