Fetching cursor output from PostgreSQL Ref Cursor in knime

KNIME Analytics Platform
1

I am trying to get data from PostgreSQL with function execution where i have to get a multiple table according to certain situation it will return a single set of output column from a function.

“FETCH ALL FROM “Output”;”

by using this query i will get my table columns but i am getting this error as shown below

“ERROR DB Query Reader 3:108 Execute failed: ERROR: cursor “Output” does not exist”

Can you please help me with this error.

Thank you!

2

Hi @RkCH -

I’m not a DB expert, but one thing that jumps out at me is the double quotes around "Output". I know some SQL dialects can be finicky about quote characters - have you tried single quotes or even no quotes at all?

1 Like
3

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.