I have created a procedure that returns data in a Pl\SQL collection. What would the syntax be for calling a procedure that has an out parameter that is an associative array and accessing the data in teh collection that the procedure returns?
What is the difference between a hash cluster and an index/b-tree cluster such that the hash cluster is to be preferred when running "equality" queries and the index/b-tree is to be preferred when searching a range of values?
I am using TYPE to build a varchar array of about 5000 items (unfortunately I'm not able to use a SQL statement). The problem is that that when I execute the procedure in TOAD, it doesn't return the values I'd expect when I loop through the array. For example, if the number '6789' is part of the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.