Oracle Magazine, March/April 2019
Database Developer PL SQL ORACLE MAGAZINE MARCH APRIL 2019 92 DECLARE c_ use_ clob constant VARCHAR2 1000 keyColumn assignmentMethod CLIENT contentColumn sqlType CLOB l_ collection soda_ collection_ t BEGIN l_ collection DBMS_ SODA create_ collection ClobCollection c_ use_ clob END Ive shown you how to insert a document What if you need to remove one Call the remove_ one method This method accepts the key for your document which you can obtain from the documents get_ key method In the block below I Create a collection Insert a document and get back the metadata Use the find_ one method to verify that it is there Invoke the remove_ one method to remove the document Call find_ one again to confirm that it is gone DECLARE l_ collection soda_ collection_ t l_ new_ document soda_ document_ t l_ found_ document soda_ document_ t BEGIN l_ collection dbms_ soda create_ collection MyFriends
You must have JavaScript enabled to view digital editions.