OraFAQ Forum: Precompilers, OCI & OCCI

Home » Developer & Programmer » Precompilers, OCI & OCCI » sql connection

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

sql connection [message #292504]

Wed, 09 January 2008 01:45

satish@123
Messages: 15
Registered: February 2006

Junior Member

The below is my sample cc file code
struct sqlexd sqlstm;
//some code
sqlstm.stmt = "select * into :s1:s2 ,:s3:s4 ,:s5:s6 ,:s7:s8 from " //select statement

switch(sqlca.sqlcode)
{
case 0:
return success;
default:
return error;
}

while debugging before executing sql statement i stopped the oracle by shutdown abort. sqlca.sqlcode shown as -3114. I started oracle and i executed sqlstm.stmt even now alse sqlca.sqlcode is showing as -3114 (even after starting oracle).

Please tell me what could be the reason for this?

Report message to a moderator

Re: sql connection [message #292519 is a reply to message #292504]

Wed, 09 January 2008 02:06

Michel Cadot
Messages: 68421
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Did you reconnect?

Regards
Michel

Report message to a moderator

Re: sql connection [message #292531 is a reply to message #292519]

Wed, 09 January 2008 02:51

satish@123
Messages: 15
Registered: February 2006

Junior Member

steps that i did

1. Placed a break point in sqlstmt
2. stopped the oracle
3. executed the query
4. in the switch statement sqlca.sqlcode shown -3114
5. went back to sqlstmt breakpoint (in the same process)
6. started the oracle
7. executed the query
8. switch statement again shown -3114 but i started the oracle.

After starting oracle will it be a new instance?
sqlca will refer to old instance even if i started oracle?

Report message to a moderator

Re: sql connection [message #292547 is a reply to message #292531]

Wed, 09 January 2008 03:27

Michel Cadot
Messages: 68421
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

So you didn't reconnect and you got the code "ORA-03114: not connected to ORACLE", I don't see anything strange in this.

Regards
Michel

Report message to a moderator

Previous Topic:	pro*c compilation error
Next Topic:	Debian: Pro*C doesn't work well with gcc 4.1 system?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 29 18:32:00 CDT 2023