| Pro*C program throwing error [message #94500] |
Thu, 23 December 2004 21:53  |
Thavamani and Sheethal
Messages: 2
Registered: December 2004
|
Junior Member |
|
|
Hi,
We have upgraded from oracle 8.1.6 to 9.2. When we are running our pro*c program which is having an update statement like this
Update
set column_value=:hostvariable:indicatorvariable
where <condition>;
update profile
set org_code=:master_org_code:master_org_code_ind
where profile_id=12345;
It is not updating and giving us ORA-3114 error. but with 8.1.6 it works fine.
Please Help
-Thava and Sheethal
|
|
|
|
| Re: Pro*C program throwing error [message #94502 is a reply to message #94500] |
Fri, 24 December 2004 01:18  |
Kaustubh Deshpande
Messages: 32
Registered: March 2004
|
Member |
|
|
Hi,
Give us more details.
1. What is ur platform ? are you running proc on windows or unix.
2. If windows, have supplied libraries of Oracle 9 and recompiled proc programs again ?
3. Can you execute any statement bfore update, is connection established properly as 3114 is for "NOT CONNECTED TO ORACLE"
regards,
Kaustubh
|
|
|
|
| Re: Pro*C program throwing error [message #94504 is a reply to message #94502] |
Fri, 24 December 2004 03:12 |
sheethal
Messages: 2
Registered: December 2004
|
Junior Member |
|
|
hi,
1.we are working on unix
3.before the update we are successfully selecting from the same table and we are able to display the values.
the pro*C code executes when we remove the indicator variable from the update/insert statements.
please help
|
|
|
|
| Re: Pro*C program throwing error [message #94516 is a reply to message #94500] |
Thu, 30 December 2004 22:28 |
Giridhar
Messages: 38
Registered: May 2001
|
Member |
|
|
When we look at the error code, it says "not connected to ORACLE". As we dont know much details about your system,pls verify if there is error handling after CONNECT Statement. Did you have any error handling after connect statement? Is this the first sql statement being executed in the program? is there any statement before this statement got executed without any error?
Giridhar
|
|
|
|
| Re: Pro*C program throwing error [message #94519 is a reply to message #94516] |
Sun, 02 January 2005 20:56 |
sheethal
Messages: 2
Registered: December 2004
|
Junior Member |
|
|
hi,
yes there is error handling after the connect statement..
we have written code to display the error code and message.
also we are successfully selecting values from a table.
that's y we r not able to really understand this error,as ,when we remove the indicator variables in the insert/update statements the programs run fine
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
