| Oracle Types and JDBC [message #472710] |
Mon, 23 August 2010 07:37  |
Prajakta001
Messages: 52
Registered: June 2008
Location: Mumbai
|
Member |
|
|
I have received a mail with following description...
do not have much information other than this .....
I tried to serach online but could not get definite answer.
I think it should something related to connections ..
Can anyone have any pointers on the same:
We are facing an issue with Oracle Types. When the JDBC driver converts the Java ObjectStream to Oracle Objects, it looks like Oracle is reading a null value. The deployment is working fine in the Dev environment, but the issue is noted in the QA env. We could notice a difference in the NLS Charset between the two DBs.
Dev Charset - US7ASCII
QA Charset - WE8ISO8859P15
Below is the description of the issue. Let me know if anyone has any pointers on this issue.
Problem:
Application sends an object to the procedure using the Oracle Object Types. Procedure then takes values from the object and performs insert or updates to the tables.
CUE DEV: This currently works on this environment and has no problems getting the values from the object.
CUE QA/UAT/PROD: This currently DOES NOT work on these environments. When the object is passed it gets a null reference for all the vales in the object. Hence the insert or update fails. Following error is returned when the procedure tries to add null values
ORA-01400: cannot insert NULL into BAIS"."BAS_APPNAME_MST"."APP_NAME")
ORA-06512: at "BAIS.USP_COD_ADDAPPLICATION", line 21
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
