Home » Infrastructure » Windows » PL/SQL: ORA-02185: a token other than WORK follows COMMIT ORA-06550: (Window 2003,oracle 11g)
PL/SQL: ORA-02185: a token other than WORK follows COMMIT ORA-06550: [message #495560] Mon, 21 February 2011 03:26 Go to next message
pradies
Messages: 250
Registered: May 2008
Senior Member
Hi,

I am facing the below mentioned error with .net framwork and oracle.


PL/SQL: ORA-02185: a token other than WORK follows COMMIT
ORA-06550: line 1, column 7:
PL/SQL: SQL Statement ignored
Re: PL/SQL: ORA-02185: a token other than WORK follows COMMIT ORA-06550: [message #495562 is a reply to message #495560] Mon, 21 February 2011 03:37 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
commit can be followed with an optional keyword work - from the error you appear to have some other keyword after commit.
Re: PL/SQL: ORA-02185: a token other than WORK follows COMMIT ORA-06550: [message #495563 is a reply to message #495562] Mon, 21 February 2011 03:43 Go to previous messageGo to next message
pradies
Messages: 250
Registered: May 2008
Senior Member

I am using below code,pls check and help me.


OracleHelper.ExecuteNonQuery(getConnection(), CommandType.Text, "update TBL_SN_AUTHO set STATUS=2 where SN_TYPE=1 and ANI='" + ani + "'");
OracleHelper.ExecuteNonQuery(getConnection(), "COMMIT");

Regards,
Pardeep.
Re: PL/SQL: ORA-02185: a token other than WORK follows COMMIT ORA-06550: [message #495567 is a reply to message #495563] Mon, 21 February 2011 03:58 Go to previous message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
Try tracing the session in the DB to see what commannd is actually issued.
Previous Topic: stuck up while installing oracle 10g
Next Topic: Connecting Oracle to Remote Access Server
Goto Forum:
  


Current Time: Fri Mar 29 08:38:21 CDT 2024