Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Useing Oracle developmer 2000 as front-end connected to MYSQL

125108Jul 27 2004 — edited Feb 22 2005

Hello All,

Due to some business requirement, we have to run the Oracle developer 2000 front end onto a MYSQL Server backend , which runs on client/server environment, we managed to get the ODBC driver working and connected to MYSQL without problem, most of the features and fields are working fine ,

EXCEPT :
the date , datetime field is not working, example, if i INSERT a record into the MYSQL via command line, it can appear in my Oracle FORMS 5.0 without problem, BUT when i enter a date in the oracle forms and save , error come out :

OCA-30010: Oracle to ODBC datatype conversion error

i tried all the combination of dates , time , i also tried changing the format MASK to all kind of combination.. it did not work...

any advice any one ??

thank you.

foo haw-jan
Malaysia.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 22 2005

Added on Jul 27 2004

#forms, #moved-from-devops

1 comment

225 views