Oracle Magazine, July/August 2019
Database Developer PL SQL ITERATING THROUGH ALL DOCUMENTS The SODA API offers a cursor to make it easy for you to iterate through all documents ORACLE MAGAZINE JULY AUGUST 2019 95 returned by the FIND and FILTER methods DECLARE l_ document soda_ document_ t l_ cursor soda_ cursor_ t l_ content_ shown BOOLEAN FALSE l_ status BOOLEAN BEGIN l_ cursor dbms_ soda open_ collection FriendsWithDocs find get_ cursor Loop through the cursor WHILE l_ cursor has_ next LOOP l_ document l_ cursor NEXT IF l_ document IS NOT NULL THEN DBMS_ OUTPUT put_ line Document key l_ document get_ key IF NOT l_ content_ shown THEN Just show content once to reduce output volume
You must have JavaScript enabled to view digital editions.