Home » Developer & Programmer » Precompilers, OCI & OCCI » Pro*C program throwing error
Pro*C program throwing error [message #94500] Thu, 23 December 2004 21:53 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous message
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
Previous Topic: 1.why and when we have to use memset in pro*c programming give the full details
Next Topic: How to compile LOB Demo
Goto Forum:
  


Current Time: Fri Mar 29 01:19:22 CDT 2024