townsendEbmud
Member²
When a pipelined function returns a table of results, and the table is accessed in a SELECT statement with the table() function, the results are null (command or sql window) 
. The results are non-null when the exact same SELECT is run in SQL*Plus. I can provide a sample pipelined function if you need it. The SELECT statement that accesses the result table looks like this:
SELECT *
FROM TABLE(PARSE_STREET('399 W GRAND AVE'))
Please fix. Thanks.
. The results are non-null when the exact same SELECT is run in SQL*Plus. I can provide a sample pipelined function if you need it. The SELECT statement that accesses the result table looks like this:SELECT *
FROM TABLE(PARSE_STREET('399 W GRAND AVE'))
Please fix. Thanks.
