Re: [sqr-users] Help reg. ORA-01460: unimplemented orunreasonableconversion

["Larry Roux" <lroux@syr.edu>]

My guess is that it is in the to_date() functions.  Also, are you sure
you are passing the correct field types (ie #var into a number field and
$var into a character field)?

90% of my coding errors are found just by pasting the code into a SQL
Tool with the variables filled in.  Usually a SQL tool will leave the
cursor at a place where the error occured, giving you a good idea where
to start. 




Larry Roux
Syracuse University
lroux@syr.edu

>>> l_srini_vasan@yahoo.com 01/30/05 11:08 PM >>>
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


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