ORA-01458: invalid length inside variable character string

From: <v0139992_at_gepex.ge.com>
Date: Wed, 06 Jan 1999 14:58:03 GMT
Message-ID: <76vtlp$hfu$1@nnrp1.dejanews.com>

Hi,

while opening the JAN-99 period in Oracle GL we get this error message. Anyone has any experience with this?
Any suggestion welcome.

The full message follows.

insert into gl_posting_interim ( code_combination_id, period_name, set_of_books_id, currency_code, period_year, period_num, period_type, account_type, bal_seg_value, actual_flag,period_net_dr, period_net_cr, period_net_dr_beq, period_net_cr_beq,quarter_to_date_dr, quarter_to_date_cr, project_to_date_dr, project_to_date_cr, begin_balance_dr, begin_balance_cr, begin_balance_dr_beq, begin_balance_cr_beq,translated_flag, SEGMENT1 , SEGMENT2 , SEGMENT3 , SEGMENT4 , SEGMENT5 , SEGMENT6 , SEGMENT7 , SEGMENT8 ) values ( 30618, 'JAN-99', 20, 'FIM', 1999, 1, '1', 'O', '200205', 'A', 0, 0,0,0, 0, 0, 0, 0, 0, 0, 7.53, 0, 'R', '200205' , <x gloire: errexit() 06-JAN-1999 14:25:42 SHRD0180: gloroc() - Performing action >> Error returned by gloire... SHRD0026: Current system time is: 06-JAN-1999 14:25:42

---

sqlcaid: sqlabc: 0 sqlcode: -1458 sqlerrml: 59 sqlerrmc:
ORA-01458: invalid length inside variable character string

sqlerrp:  	sqlerrd: 0 0 0 0 0 538976288
sqlwarn:           sqltext:


*****************************************************



oracaid:  	oracabc: 0

oracchf: 0 oradbgf: 0 orahchf: 0 orastxtf: 2 orastxtl: 70 orastxtc:
update gl_posting_interim pi1 set pi1.begin_balance_dr=(pi1.begin_bala

orasfnmc: gloire.lpc  oraslnr: 1271  orasfnml: 10
orahoc: 50  ormoc:  7  oracoc: 2
oranor: 0  oranpr: 14  oranex:  15

SHRD0015: gloire failed:

SHRD0033: Error Status: 0
SHRD0103: Function warning number: -1

---

SHRD0044: Process logging off database and exiting ...

<x gluccf() 06-JAN-1999 14:25:42

+---------------------------------------------------------------------------+

Concurrent request completed
Current system time is 06-JAN-1999 14:25:42

+---------------------------------------------------------------------------+

'481000401' , '000000' , '0' , '000' , '000' , '000' , '0000' )

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Jan 06 1999 - 08:58:03 CST