Hello,

I've got a little problem with Oci8.

I've a debian server with Oci8, PHP5 and Apache2.

When I try to connect to the oracle DB, I've got the following message :

ORA-00604 Error occurred at recursive SQL level 1 ORA-01756 : quoted string
not properly terminate.

Is-it a problem with the NLS_LANG ?

Thanks a lot for ideas ...

Regards

Jean-Marie VIGNEAUD <jm.vigneaud@gironde.chambagri.fr> wrote:
> I've got a little problem with Oci8.
>
> I've a debian server with Oci8, PHP5 and Apache2.
>
> When I try to connect to the oracle DB, I've got the following message :
>
> ORA-00604 Error occurred at recursive SQL level 1 ORA-01756 : quoted string
> not properly terminate.
>
> Is-it a problem with the NLS_LANG ?

Either that, or with NLS_DATE_FORMAT, or with NLS_TIMESTAMP_FORMAT etc.

Search for weird settings in your environment!

Yours,
Laurenz Albe