pass-through SQL

From: Ganesh Kamath D <ganesh.kamath_at_in.bosch.com>
Date: Fri, 6 May 2005 09:21:12 +0530
Message-ID: <d5epjk$15p$1@ns2.fe.internet.bosch.com>

Hello,

I am using heteregeneous services to access SQL Server 2000 data from Oracle 9i. The table has 28 columns. I am using a loop to fetch the column values

dbms_hs_passthrough.get_value_at_dblink(cursor, counter, value)

This works fine till 24 columns. After that it gives the following error message:
ORA-28553: pass-through SQL: invalid bind-variable position

Can anybody help me?

thanks,GK Received on Thu May 05 2005 - 22:51:12 CDT