Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
nstefaniuk
Creator III
Creator III

[10SR4] Oracle silent errors

Hello all,

I have an issue with 10 SR4.

The oracle errors are silent in SR4 when they are not in SR2.

With this code (after a CONNECT of course), you should get an Oracle error (dividing by zero).

data:

Load

*

;

SQL

select

1/0 "test" from dual

;

drop table data;

In SR2 i get the error but in SR4 I don't, and so in SR4 I just have the table missing error (because the table is not created).

I haven't found a parameter to manage it.

I am in 32 bits on Windows 7, but same in 64 bits on 2003 server

Thanks for help

11 Replies
nstefaniuk
Creator III
Creator III
Author

Tested with Qlikview SR4 with OraOLEDB11.dll on a Oracle 11 XE, same issue: the oracle error is silent.

I just don't understand why it works for you Ralf.

In ODBC the error is retrieved.

rbecher
MVP
MVP

I'm on Win7 64-bit. So, it's a different environment.

Astrato.io Head of R&D