Oracle Magazine, May/June 2018
Database Developer PL SQL ORACLE MAGAZINE MAY JUNE 2018 71 LOOP IF l_ nums get_ number indx IS NULL THEN l_ nums remove indx END IF END LOOP DBMS_ OUTPUT put_ line l_ nums stringify END After execution I see this text displayed 123 123456 19e10 This block takes advantage of the fact that the default mode for error handling with PL SQL JSON object type methods is to return NULL if there is an error So I just check to see if the result of get_ number is NULL If I escalate error handling in this same block by putting this line l_ nums on_ error 1 right after the BEGIN it will fail with this unhandled exception when I run the block ORA 40566 JSON path expression selected a value of different data type
You must have JavaScript enabled to view digital editions.