ORA-22275: invalid LOB locator specified
A pure PL/SQL reporting engine (transforms jrxml to PDF)
Brought to you by:
aweiden
Menu
▾
▴
Andreas,
getting the above. Report runs in the ireport fine.
I pass p_mnth ="08/01/2015" as a string with further conversion as to_char(to_date(p_mnth,'MM/DD/YYYY'),'MM/YYYY'). This allows me to avoid "invalid number" error.
Please advise.
but is seemes ( based on the 0 seconds in processing time) that this query still causing a problem:
5560 14-FEB-16 03.50.56.528180 PM 0 | | Search for lexical params
5561 14-FEB-16 03.50.56.528481 PM 0 | | Parse query
5562 14-FEB-16 03.50.56.528558 PM 0 | | | Query:SELECT investor_inv_id, report_month, gross_balance, money_flow, gross, perc_change, perc_fee, gross_less_fee, net_balance FROM "VW_BALANCE" wheRE report_month = to_char(to_date(:p_mnth,'MM/DD/YYYY'),'MM/YYYY')
5563 14-FEB-16 03.50.56.530053 PM 1 | | Bind variable / to p_mnth / "01/01/2015"
5564 14-FEB-16 03.50.56.534873 PM 4 | | Execute query
5565 14-FEB-16 03.50.56.535392 PM 0 | | | Scale band
Last edit: AZZ 2016-02-14
Added report
Last edit: AZZ 2016-02-14
Aha! Again this error is an indication of an empty dataset.
in other words, when the select(s) return an empty dataset (nulls ) the entire report creates an exception.
I think it is bug, because this report has static text that has no dependency on the returned data. Is there a workaround?
Ideally i'd like to display (genereate) a pdf with empty cells if there is no data returned.