ODBC setting with Oracle
Date: May 16, 2005 02:23AM
May be I get some help here.....
I have a problem on my migration from Oracle to MySQL project..
On Oracle Developer 6 Report Builder, i use query :
SELECT NUM_OF_TRX, DATE_OF_TRX, DESC_OF_TRANS, ACCOUNT, VALUE_DB,
VALUE_CR, DATE_OF_ENTRY, USER_ENTRY
WHERE DATE_OF_TRX BETWEEN :TGL1 AND :TGL2 AND
(:PC is null or (JOURNAL.PC_CODE = :PC)) AND
(:KP is null or (JOURNAL.KP_CODE = :KP)) AND
(:BG is null or (JOURNAL.CODE_BAGIAN = :BG)) AND
(:SC is null or (JOURNAL.SECTION_CODE = :SC))
ORDER BY DATE_OF_TRX
expresion with ":" is parameter input
i put that query on SQL Query at Data Model on Oracle Developer 6 Report Builder. When I compiled the script, its doesn't have any error...... (compiled successfully), but when I run the application, it come out with this error message :
OCA-30010 : Message 3000 not found; no message file for
DATE_OF_TRX, DESC_OF_TRANS, ACCOUNT, VALUE_DB,
could some body help me...... :((
when i execute the query on sql editor, it's running well....
and when the script at Oracle Developer compiled, its successfull....
but when i ran the application, its came out with that error...
is it my ODBC setting wrong... ???
could any body know about ODBC 3.51 setting (flags 1, flags 2, flags 3... etc) for Oracle Developer ???
I use MyODBC 3.51, Oracle Developer6, EMS MySQL Manager 3, and MySQL 5.0.3
previous Database : Oracle 9i