[resolved] tparserecord set not working

Four Stars

[resolved] tparserecord set not working

dear all & thanks in advance
i have a issue for tparserecordset
components are tfixedflowinput (used for dynamic parameter) -> toraclesp (return record set based on dynamic parameter) -> tparserecordset ( parsing the record set into individual variables returned by oracle ref cursor -> tlogrow( display)


error comes as "first_name" cannot be resolved, please see screen shots.
Four Stars

Re: [resolved] tparserecord set not working

i did not put value in tparserecordset attribute table i.e "first_name" against the column first_name.
thanks
Seventeen Stars

Re: [resolved] tparserecord set not working

It means the recordset (the Java class ResultSet) returns records which does not contains a column called first_name.
I would check your stored procedure with another tool like SQLDeveloper if it returns a resultset containing such column.
You could also - or even better I recommend it - use upper case letters because Oracle usually converts all identifiers internally to upper case letters. 

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Have you checked out Talend’s 2019 Summer release yet?

Find out about Talend's 2019 Summer release

Blog

Talend Summer 2019 – What’s New?

Talend continues to revolutionize how businesses leverage speed and manage scale

Watch Now

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog