question

yousiftechwadhah-1241 avatar image
0 Votes"
yousiftechwadhah-1241 asked Cathyji-msft commented

MS SQL SERVER 2019 Linked with Oracle

We are facing an error when we are try to connect to Oracle DB from MS SQL server.

OLE DB provider "OraOLEDB.Oracle" for linked server "PRODUCTION_ICBS" returned message "Error while trying to retrieve text for error ORA-03113

separator not found in message(3144)separator not found in message(3142)".

Msg 7321, Level 16, State 2, Line 1

An error occurred while preparing the query "SELECT "Tbl1004"."CACC_NUM" "Col1027","Tbl1004"."OPR_DATE" "Col1029" FROM "ICBS"."NBI_REPORT_SIGCAP" "Tbl1004" WHERE "Tbl1004"."STATUS"=(1.000000000000000e+000)" for execution against OLE DB provider "OraOLEDB.Oracle" for linked server "PRODUCTION_ICBS".

Completion time: 2022-05-15T15:35:51.7485568+03:00

sql-server-generalsql-server-reporting-services
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.


Did you try some simpler, shorter queries, just to check the connection?


0 Votes 0 ·

Hi @yousiftechwadhah-1241,

Did your issue have any progress? Did you check the method that others mentioned?

0 Votes 0 ·
OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

Error while trying to retrieve text for error ORA-03113

That's an Oracle error message raised from Oracle, so you have to troubleshot it on that side.
https://support.oracle.com/knowledge/Oracle%20Database%20Products/1506805_1.html

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

NaomiNNN avatar image
0 Votes"
NaomiNNN answered

In the query did you try to remove all double quotes and also use Status = 1 instead of what you're trying right now? Just to see if this would execute?

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.