Advertisements

Call stored procedure Oracle ODBC

Use

SQL CALL

https://community.qlikview.com/thread/12849

Advertisements

Oracle in OraClient 12Home2, #Qlikview, and case of field names capitalization

This was an annoying one for a bit.

Say you have this Qlikview script

LOAD

Sales_Order

;

Select ORDER_NUMBER as Sales_Order from…. ;

Well, it won’t work because the Oracle ODBC driver uppers all the returned field names, or Oracle does? Who knows?

Anyways, to make it work

LOAD

SALES_ORDER