Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Insert into datetime column over dblink to MSSQL

user519523Aug 2 2013 — edited Aug 2 2013

Hello,

i am trying to insert date/time value into a table located in linked MSSQL server from PL/SQL code, but without success.

When performing INSERT INTO target_table@link_name (col1, col2) VALUES ('test', CURRENT_DATE), then I get errorcode ORA-02070 database link_name does not support operator 293 in this context

When performing INSERT INTO target_table@link_name (col1, col2) VALUES ('test', NULL), then all is fine and new record in the target table is created.

Column col1 is varchar, col2 is datetime.

I tried also provide the date value in various forms of a string, but always got some errors as well.

Local DB is Oracle 10.2.0.3 on Windows Server 2003, remote DB is MSSQL 2008 on Windows 2008 Srv R2. The link is made using oracle heterogenous services.

Does anybody have any idea how to provide date/time value for such insert statement?

thanks

Zdenek

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 30 2013
Added on Aug 2 2013
4 comments
2,869 views