OraFAQ Forum: Windows » PL/SQL: ORA-02185: a token other than WORK follows COMMIT ORA-06550:

Home » Infrastructure » Windows » PL/SQL: ORA-02185: a token other than WORK follows COMMIT ORA-06550: (Window 2003,oracle 11g)

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

PL/SQL: ORA-02185: a token other than WORK follows COMMIT ORA-06550: [message #495560]

Mon, 21 February 2011 03:26

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

Report message to a moderator

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

cookiemonster
Messages: 13904
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.

Report message to a moderator

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

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.

Report message to a moderator

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

cookiemonster
Messages: 13904
Registered: September 2008
Location: Rainy Manchester

Senior Member

Try tracing the session in the DB to see what commannd is actually issued.

Report message to a moderator

Previous Topic:	stuck up while installing oracle 10g
Next Topic:	Connecting Oracle to Remote Access Server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Mar 26 04:43:45 CDT 2023