Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem with stored procedure columns

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

12 Replies
Not applicable
Author

Can somebody help me with this?

blaise
Partner - Specialist
Partner - Specialist

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

Not applicable
Author

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.