I've created a table structure and returning the results in table format.
I'm able to get the result in Oracle using the below query:
SELECT * FROM TABLE(schemaname.func_name'userid')) where user id is the input parameter.
But when I'm putting it in COnnect-SQL, under Browse tab, I'm getting the error message:
There was a problem performing a database query: There was a problem getting a list: code: 933 SQLState: 42000 Message: ORA-00933: SQL command not properly ended
DatabaseException caused by prior exception: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended