SQL Language (MOSC)

MOSC Banner

Error when inserting data into remote data base using dblink

edited Feb 2, 2013 2:49AM in SQL Language (MOSC) 8 commentsAnswered
Hi,

     I am using "insert into select" statament to insert data into remote data base using dblink. And the sql query has multiple column with case statement.But When I try to execute a query to insert data into remote data base,I am getting the below error.Can any one please let me know the cause of this error ?

SQL Error: ORA-02070: database  does not support  in this context
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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center