PL/SQL (MOSC)

MOSC Banner

Dynamically defining a Table Function's structure

edited Jul 16, 2020 9:52PM in PL/SQL (MOSC) 6 commentsAnswered

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 NULLs 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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center