Return an Oracle Associative Array from a function
- by Paul Johnson
Does anybody know if it is possible to return an associative array as the result of an Oracle function, if so do you have any examples?
I have an Oracle package which contains an associative array declaration as defined below:
TYPE EVENTPARAM IS TABLE OF NUMBER
INDEX BY BINARY_INTEGER;
This is then used in a stored procedure outside the…