Oracle Error messages?

[eluser]inari[/eluser]
When i'm using MySQL with CI I'm getting all errors if something gets wrong, but with Oracle, only message that I get is:

An Error Was Encountered

Error Number:

SELECT * FROM clients

No numbers, no messages.
Any ideas?

[eluser]Derek Allard[/eluser]
I assume you do in fact have a table called clients? What happens if you run that query directly against the db (in other words, not through CI)?

[eluser]inari[/eluser]
This is SQL called from CI:

Code:

SELECT * FROM clients where fgfg = 1

This is error message from CI:

An Error Was Encountered

Error Number:

SELECT * FROM clients WHERE fgfg = 1

This is SQL called from Oracle SQL Developer:

Code:

SELECT * FROM clients where fgfg = 1

This is error message from Oracle SQL Developer:

SELECT * FROM clients where fgfg = 1
Error at Command Line:1 Column:28
Error report:
SQL Error: ORA-00904: "FGFG": invalid identifier
00904. 00000 - "%s: invalid identifier"

Table "clients" exist, field fgfg does not exist.

[eluser]Derek Allard[/eluser]
So the error is getting thrown. The code in the Oracle driver is oci8. I know you're on a newer version. I don't use Oracle or have a test machine set up, so any insight you can provide would be helpful.

[eluser]inari[/eluser]
I looked up oci8_driver and only clue I got when I tried to cause error is that method _error_message() at line 488 returns nothing, and $array array is just empty, no "message" key within.


Error reporting is very important to me because there is much bigger bug that is showing up randomly.
Once in a while 'select' operation fails and produces error message, but immediately after refreshing page it just past clearly like nothing happened. It scares me out and i can't catch even error message.

If I can help in any way, please just tell me, if required you can contact me at email for any further tests you need or just post it here.

[eluser]fszostak[/eluser]
I have same problem with CI 1.7.3.
Anybody have can help me?