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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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