Link to home
Create AccountLog in
Avatar of mastek_user
mastek_userFlag for India

asked on

ORA-28500 Oracle to SQL Server Hetero database link for large inserts

i've written a procedure in Oracle which reads records through cursor from SQL server table and insert into another table in sql server. The access of tables is through heterogeneous database link. This works fine for say 100 records but for large no of records i get exception
"ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC]
ORA-02063: preceding 2 lines from DBLINKNAME
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

I'm not a SQL Server person.  I'm responding to a Neglected question alert.

There's not a lot of error messages to work with.  I suggest you contact Oracle Support on this one since no other Expert has shown up.
Avatar of mastek_user

ASKER

i'm using Oracle 10g XE(10.2) edition. Another observation the insert succeeds if its run from anonymous block. but fails when run through a procedure
ASKER CERTIFIED SOLUTION
Avatar of mastek_user
mastek_user
Flag of India image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
no