Calling Pro*C from Oracle Application Server Forms Services results in ORA-12705
(Doc ID 341560.1)
Last updated on FEBRUARY 14, 2023
Applies to:
Oracle Fusion Middleware - Version 9.0.4.1.0 to 10.1.2.0.0 [Release AS10g to AS10gR2]Oracle Forms - Version 10.1.2.3.0 and later
Information in this document applies to any platform.
Oracle Forms - Version: 9.0.4 to 10.1.2
This problem can occur on any platform.
Oracle Application Server Forms Services (10g 9.0.4 ~ 10.1.2)
Infrastructure and Middle tier - Forms Services, version 9.0.4 + patch 1
Symptoms
-
Pro*C application compiled on 9.2.0.7 client does not work from Oracle 10g OAS 9.0.4.1 or 10.1 environment.
-
Calling a Pro*C application from Oracle 10g OAS through a form results in 'ORA-12705: invalid or unknown NLS parameter value specified'.
-
Same Pro*C application works fine as a standalone on Oracle 9i 9.2.0.6 or 9.2.0.7 client.
-
Problem is to call the the Pro*C program from an Oracle Form.
-
Calling the Pro*C via an shell script, if executed from command line the Pro*C application works fine.
-
If executed from Form via host built-in the Pro*C application gives the error - ORA-12705
Changes
- Application Server 10g (9.0.4.1) with 9.2.0.6 or 9.2.0.7 database server.
- Application Server 10g (9.0.4.1) does not come with Pro*C, it is installed on different ORACLE_HOME.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |