MySQL Forums
Forum List  »  Connector/ODBC

ODBC setting with Oracle
Posted by: cybe2000
Date: May 16, 2005 02:23AM

May be I get some help here.....

Please help....

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
FROM JOURNAL
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

note:
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
product=oca60,facility=UB==>SELECT NUM_OF_TRX,
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

thx

Options: ReplyQuote


Subject
Written By
Posted
ODBC setting with Oracle
May 16, 2005 02:23AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.