Home » SQL & PL/SQL » SQL & PL/SQL » i have logged on but it still report" ORA-01012: not logged on"
icon5.gif  i have logged on but it still report" ORA-01012: not logged on" [message #198014] Fri, 13 October 2006 16:20 Go to next message
wanglesi
Messages: 3
Registered: October 2006
Junior Member
I use oracle with C++.When I use SELECT statement it is ok, but when use UPDATE or DELETE, it will report this,why?
part of the code is following
exec sql CONNECT :username IDENTIFIED BY :password;
sql_statement.len = strlen((char *) sql_statement.arr);

exec sql PREPARE S8 FROM :sql_statement;
exec sql execute S8;
exec sql commit work release;

Thanks a lot!
Re: i have logged on but it still report" ORA-01012: not logged on" [message #198073 is a reply to message #198014] Sat, 14 October 2006 06:15 Go to previous messageGo to next message
amul
Messages: 252
Registered: April 2001
Location: Chennai
Senior Member
be happy that you are logged in.but i am not sure what you are trying to achieve...
Re: i have logged on but it still report" ORA-01012: not logged on" [message #198090 is a reply to message #198014] Sat, 14 October 2006 12:23 Go to previous message
wanglesi
Messages: 3
Registered: October 2006
Junior Member
I just want to update data in the database Embarassed
Previous Topic: problem in dbms_random.
Next Topic: Trigger Mutating issue
Goto Forum:
  


Current Time: Thu Dec 08 01:56:47 CST 2016

Total time taken to generate the page: 0.05983 seconds