SQL Query Engineering Settlement Sub-paragraph transfer out

Total one loan project settlement negative loan project settlement hedging problem

Oralce uses the aggregate function Wmsys.wm_concat field to display Clob: should be, 10.2.0.4 before, is varchar2,10.2.0.5 start, is Clob this is a bug that can trigger when the LOB field and order by occur simultaneously The corresponding patch can be hit, or, as long as not more than 4000 bytes, you can add a to_char to convert to a string to try

Selectgl_detail.explanation, Bd_accsubj.subjcode, Bd_accsubj.dispname, Gl_detail.debitamount Debit, Gl_detail.creditamount Credit, Gl_detail.prepareddatev single date, gl_voucher.no voucher number, To_char (wmsys.wm_ Concat (Gl_freevalue.valuecode)) Valuecode, To_char (Wmsys.wm_concat (gl_freevalue.valuename)) ValueName fromGl_detail, BD_ACCSUBJ, Bd_glorgbook,gl_freevalue,gl_voucherwhereGl_detail.pk_accsubj=BD_ACCSUBJ.PK_ACCSUBJ andGl_detail.pk_glorgbook=Bd_glorgbook.pk_glorgbook andGl_detail.assid=Gl_freevalue.freevalueid andGl_detail.pk_voucher=Gl_voucher.pk_voucher andGl_detail.dr= '0'    andGl_detail.yearv=' the'    andBd_glorgbook.glorgbookcode= '015101-0001'    andBd_accsubj.subjcode like '2123%'     andGl_detail.creditamount<0   Group  bygl_detail.explanation, Bd_accsubj.subjcode, Bd_accsubj.dispname, Gl_detail.creditamount, Gl_detail.debitamount, gl_detail.prepareddatev,gl_voucher.noOrder  byGl_detail.prepareddatev,gl_voucher.no

SQL Query Engineering Settlement Sub-paragraph transfer out