[sqr-users] Help reg. ORA-01460: unimplemented or unreasonableconversion

[Srinivasan L <l_srini_vasan@yahoo.com>]

When i'm inserting to a table it gives me this error.

Application / System Error|1460.000000000000000|ORA-01460: unimplemented or
unreasonable conversion

the insert statement is 

begin-sql on-error=Catch_SQL         
    insert into PROBLEMTABLE ( 
        SC_CODE, ACADEMIC_YEAR, LVL_XCODE, STR_XCODE, 
        CDATE1, CDATE2, CDATE3, CDATE4, T1DAYS_NO, T2DAYS_NO, 
        T3DAYS_NO, T4DAYS_NO, S1DAYS_NO, S2DAYS_NO, 
        T1START_DATE, T1END_DATE, T2START_DATE, T2END_DATE, 
        T3START_DATE, T3END_DATE, T4START_DATE, T4END_DATE)
        values ( $gSCCode, $NAcadYr, $gLvlCode, $termStrmCode,
          TO_DATE($t1end_date, 'DD/MM/YYYY'),TO_DATE($t2end_date,
'DD/MM/YYYY'),
          TO_DATE($t3end_date, 'DD/MM/YYYY'),TO_DATE($t4end_date,
'DD/MM/YYYY'),
          #t1days_no, #t2days_no, #t3days_no, #t4days_no,
#s1days_no,#s2days_no,
          TO_DATE($t1start_date, 'DD/MM/YYYY'),
          TO_DATE($t1end_date, 'DD/MM/YYYY'),
          TO_DATE($t2start_date, 'DD/MM/YYYY'),
          TO_DATE($t2end_date, 'DD/MM/YYYY'),
          TO_DATE($t3start_date, 'DD/MM/YYYY'),
          TO_DATE($t3end_date, 'DD/MM/YYYY'),
          TO_DATE($t4start_date, 'DD/MM/YYYY'),
          TO_DATE($t4end_date, 'DD/MM/YYYY'))
  end-sql
    end-if


When i print the values b4 printing its giving all the values correctly.

I'm able to insert to other tables...

All the values are withing the varchar range and the date filds are ok.

Can anyone help me in this regard.

Thx
Srini

=====
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
May today be better than yesterday, but, not as good as tomorrow.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


        
                
__________________________________ 
Do you Yahoo!? 
Yahoo! Mail - You care about security. So do we. 
http://promotions.yahoo.com/new_mail

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users