Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Qlik-members!
I have a problem with a stored procedure i run in my load script because my company has changed something.
One month ago the procedure gave me a normal table.
Since one week the same procedure has some extra columns.
Now is the problem that my colleague has made a &*#*&$!! mistake and the procedure gives me a table with two columns who has the same name......
How can is select those both individually?
I hope you can help me
Kind Regards,
Martijn
Can somebody help me with this?
please post the statement you use to extract the data using the PL/SQL stored procedure and nothing else (ie create an application that only extracts the data from PL/SQL stored procedure).
Please post a screenshot of the table viewer where all fields are visible.
Br Blaise
I'm not sure select * will work in this situation.
I get the same thing that you get. When OLEDB driver (and ODBC) reaches the duplicate column name, it throws ODBC/OLEDB read failed.
Can you rename the column on the sql side ? Having two columns with the same name, while allowed in SQL, seems confusing.
If you cannot rename the column in that procedure, create anohter one or have it return an alternate name based on the calling program.