Missing data from Oracle view with 11g client

stephencredmond — Thu, 06 Oct 2011 09:52:26 GMT

Hi All,

This is an Oracle issue, not a QlikView one, but I am wondering if anyone has come across it.

My customer has a view that makes several calls to a package to retrieve values. The view code looks something like this:

SELECT i.invoice_id

my_pkg.invoice_status(i.invoice_id),
my_pkg.current_approver(i.invoice_id),
my_pkg.days_with_current_approver(i.invoice_id),
mp_pkg.view_file_url(i.invoice_id)

FROM ap_invoices_all i

Now, on his QlikView desktop, which is using an older version of the Oracle client and 32-bit (I think it is the Oracle 9 client), the SELECT * FROM VIEWNAME returns all the records and all the data as expected. When we run the same QVW on the server, it only returns values for the invoice ID and the status (the result of the first package call) - all the other values are null. Only difference is that the server has the 64bit 11g client.

Any Oracle gurus out there who might shed some light on this?

Regards,

Stephen

Re: Missing data from Oracle view with 11g client

Thu, 06 Oct 2011 14:56:35 GMT

Normally connecting from higher version to lower version in oracle has no problems. Atleast I never faced one. But we do get problem while using x64 on x32. You can try to force this to 32 bit from qv connection panel.

Hope this helps you.

Regards,

Kiran.

topic Missing data from Oracle view with 11g client in QlikView

Missing data from Oracle view with 11g client

Re: Missing data from Oracle view with 11g client