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: 
DaveL
Contributor III
Contributor III

How to use tOracleRow with tParseRecordset

I can't get this working and wonder if I'm trying something that isn't possible.  Any help would be appreciated.
I have a row coming into a tOracleRow component and when the row comes in I want to pull the next available Oracle sequence value to use as my insert key. You can see the error that comes back.  I've tried every combination I can think of, must be something simple I overlooked.
0683p000009MDmd.jpg 0683p000009MDiI.jpg 0683p000009MDmi.jpg
Labels (2)
2 Replies
Anonymous
Not applicable

In the tParseRecordSet you have to set the column names from the result set separately in the Attribute table as value.
The schema names does not matter here. This way you can get different columns in your query and put the values in various schema columns.
DaveL
Contributor III
Contributor III
Author

Ah, thanks for the input.  That was the problem.