Dynamically defining a Table Function's structure
I'm attempting to dynamically define a table function using a value entered by the user. My Oracle version 11.2.0.1
I'm using the ODCITableDescribe, ODCITablePrepare, ODCITableStart, etc interface functions as described in the documentation.
As seen in the documentation for ODCITableDescribe:
"Any arguments of the table function that are not constants are passed to ODCITableDescribe
as NULL
s because their values are not known at compile time.".
I'm calling the table function as: select * from table(CommsPortLevelObj.do('MyNode')); where I expect 'MyNode' to be a constant that is passed as a parameter to the ODCITableDescribe and ODCITablePrepare functions as is so I can dynamically create the structure of the table. Unfortunately, the argument is always NULL which prevents me from defining the structure.