Oracle Magazine, July/August 2019
Database Developer PL SQL OPERATION CHAINING Method chaining is a common practice in object oriented programming but less familiar in the procedural world and PL SQL is a procedural language When coding your read and write operations on documents you will usually chain together several of the nonterminal methods listed previously First heres a block of code that does not use method chaining DECLARE l_ collection soda_ collection_ t l_ operation soda_ operation_ t l_ cursor soda_ cursor_ t l_ status BOOLEAN BEGIN l_ collection dbms_ soda open_ collection FriendsWithDocs ORACLE MAGAZINE JULY AUGUST 2019 93 l_ operation l_ collection find l_ cursor l_ operation get_ cursor l_ status l_ cursor close END I start the block by opening my collection Then I call the FIND method to return an instance of the SODA_ OPERATION_ T type for all the documents in the collection I will show you later in the article how to filter that FIND if you dont want them all I then
You must have JavaScript enabled to view digital editions.