OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » ORA-02070 (Oracle ,10g,Windows XP)

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

ORA-02070 [message #535999]

Sun, 18 December 2011 20:33

lonion
Messages: 97
Registered: August 2011
Location: shenzhen,China

Member

i access to the sql server 2000 by the Oracle transparent gateway.

when i try to delete a data from a table named 'AA' which is created in the sql server 2000,it occurs the following error:
/forum/fa/9634/0/

please tell me why ?

Attachment: ORA-02070.jpg
(Size: 20.65KB, Downloaded 1795 times)

Report message to a moderator

Re: ORA-02070 [message #536000 is a reply to message #535999]

Sun, 18 December 2011 20:50

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

02070, 00000, "database %s%s does not support %s in this context"
// *Cause: The remote database does not support the named capability in
//	   the context in which it is used.
// *Action: Simplify the SQL statement.
//

It appears some incompatibility exists.
I suspect each side will blame the other as being root cause of the error.

Report message to a moderator

Re: ORA-02070 [message #536002 is a reply to message #536000]

Sun, 18 December 2011 21:11

lonion
Messages: 97
Registered: August 2011
Location: shenzhen,China

Member

The data type of the column named "PREFIX" is 'nchar(10)',the same to the column named "NO". after i changed their data type for 'char(10)',the data can be deleted successfully.i can't do like that , because it is production database.

Report message to a moderator

Previous Topic:	dbms_job
Next Topic:	User restriction on database level

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Aug 17 14:52:16 CDT 2025