Hi, I am trying to create a "view" which read expand the results of a query into multiple row. for example, Source Table | name | pages | | aa | 0-3 |
Output View | name | pages | | aa | 0 | | aa | 1 | | aa | 2 | | aa | 3 | I looked at TableFunction examples. The processCursor in JdbcTest is quite close to what I need. A cursor which return me the raw data and I can expand the data. However, testTableFunctionCursorInputs is not working (currently ignored). Error (when enabled) is No match found for function signature process(<NUMERIC>, <CURSOR>) even when the function is created correctly. it seems it is not able to support CURSOR parameter type. If cursor is not working, is there any other way that I can get the Connection within the TableFunction to retrieve the raw data from table ? Thank you. Rgds, jay
