Zeos + Oracle = Erro : OCI_SUCCESS_WITH_INFO

everton · Post by **everton** » 02.07.2009, 13:55

I have a problem with a conection between the Zeos e o Oracle 10g, when i execute a select containing some columns that return values NULL, ocurring a error OCI_SUCCESS_WITH_INFO and nothing return values to my application, somebody have already at problem?

Thanks and excuse by my bad english...

javierjiron · Post by **javierjiron** » 22.03.2010, 03:44

I have the same problem, please I need help

Urios · Post by **Urios** » 19.05.2010, 14:05

OCI SUCCESS WITH INFO =

you're trying to do a SUM or an over aggregate function on a NULLABLE column.

hilam · Post by **hilam** » 08.07.2010, 02:19

I have the same problem too.

but I'm using the NVL function to prevent the SELECT NULL.

in the ORACLE documentation OCI_SUCCESS_WITH_INFO is a warning.

ZEOS should treat as a WARNING not an ERROR!

excuse my bad English, too.

hilam · Post by **hilam** » 09.07.2010, 00:22

the solution is here:

http://zeos.firmos.at/viewtopic.php?p=11795

thanks a lot.