Oracle Magazine, May/June 2018
Database Developer PL SQL DBMS_ OUTPUT put_ line l_ stuff get indx get_ size ORACLE MAGAZINE MAY JUNE 2018 65 END LOOP END Heres the output Number of elements in array 3 3 5 4 If youve been working with PL SQL as your primary language you will be in the habit of writing a FOR loop on a nested table as follows FOR indx IN 1 l_ stuff COUNT If you write the same thing for a JSON array your code will raise an error This is the one Ive seen most and it took me a little while and some tracing the first time to realize that thats what this error meant ORA 30625 method dispatch on NULL SELF argument is disallowed BUILD YOUR OWN ARRAY Sometimes an array is provided to you and you need to go exploring see Recursive Looping Through an Array Sometimes you need to construct an array from data in a table or your program
You must have JavaScript enabled to view digital editions.