Re: ORA-01458: invalid length inside variable character string

Here's some info on that error:
ORA-01458 invalid length inside variable character string

Cause: An attempt was made to bind or define a variable character string with a buffer length less than the two-byte minimum requirement.

Action: Increase the buffer size or use a different type.

Good Luck,
Satar

In article <76vtlp$hfu$1_at_nnrp1.dejanews.com>,   v0139992_at_gepex.ge.com wrote:
> 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
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Jan 08 1999 - 15:42:13 CST