MSSQ2005 - ORACLE 10g -unchartered string in SQL skript (stored procedure)

[Luboš]

Hi, sorry I don´t speak english

 

 

first server - Virtual PC WMVARE - Windows server2003 - MSSQL2005 SP3 x86

second server - ORACLE 10g

 

On MSSQ2005 linked ORACLE - use ORACLE PROVIDER for OLE DB

 

When I run SELECT

SELECT * from ORACLE..schema.table
SELECT * from OpenQuery(ORACLE,'SELECT * from schema.table' ) 
 all is Ok

When I run

DELETE SQL_table from SQL_tabla A
WHERE EXISTS (SELECT TOP 1 1 from ORACLE..shema.table B
WHERE A.column1 = B.column1)

 all is Ok

 

When I run (on the first rows is "tab" or "blank space"

    DELETE _brano_mtl_system_items_interface from _brano_mtl_system_items_interface B
where Exists (Select top 1 1 from ORACLE..APPS.XXBR_TPV2000_POLOZKY_V X
where B.polozka = X.polozka and B.organization_id = X.organizace) 

    OR when exists REM row
--SELECT * from table
DELETE SQL_tabulka from SQL_tabuka A
WHERE EXISTS (SELECT TOP 1 1 from ORACLE..shema.table B
WHERE A.column1 = B.column1)

 

Cannot get the data of the row from the OLE DB provider "OraOLEDB.Oracle" for linked server "ORACLE".
OLE DB provider "OraOLEDB.Oracle" for linked server "ORACLE" returned message "".

 

 OLE DB provider "OraOLEDB.Oracle" for linked server "ORACLE" returned message "ORA-01403: no data found".

 

It's wery simple function.  In stored procedure is it big problem.

I try various sysntax - JOIN , OpenQuery  - but nothing not help

 

Please help