Using WITH clause values as parameters in a TABLE function [message #665987] |
Thu, 05 October 2017 15:30 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/78767605c474f87a919a963d0f2fa59a?s=64&d=mm&r=g) |
orabert
Messages: 5 Registered: October 2013
|
Junior Member |
|
|
Am I missing something, or is it not permitted to use values from a WITH clause in a TABLE function in the following SELECT statement?
WITH param_values as (
select 2017 as current_year from dual
)
SELECT * FROM TABLE(my_pipelined_table_function(param_values.current_year));
Produces:
ORA-00904: "param_values"."current_year": invalid identifier
Of course, "my_pipelined_table_function" takes a single numeric value as a parameter.
The reason why I want to use the WITH clause is because the SELECT statement containing the TABLE function is actually much more complicated, but everything else works fine except the TABLE function clause.
I can't seem to find any documentation explaining the reason why Oracle may be throwing this error in this case.
Thanks so much for any insights!
|
|
|
|
|