Setting And Retrieving CLOB values in APEX with JavaScript

September 1, 2015 at 12:36 pm | Posted in Oracle Developement | Leave a comment
Tags: , , , ,

Here is a very helpful blog post by Andy Tulley on how to set/get CLOB values from an APEX collection.

https://atulley.wordpress.com/2014/02/07/setting-and-retrieving-clob-values-in-apex/

Quick Look: How to loop through an associative array indexed by varchar2.

April 16, 2012 at 10:29 am | Posted in Oracle Application Express (Apex), Oracle Developement, PL/SQL | 5 Comments
Tags: , , , , , , , , , , , , ,

Here is a quick example of how to loop through an associative array (index-by table) indexed by varchar2:


DECLARE
 TYPE t_tbl IS TABLE OF VARCHAR(1) INDEX BY VARCHAR2(1);
 l_tbl t_tbl;
 l_key VARCHAR2(1);
BEGIN
 l_tbl('a') := 1;
 l_tbl('b') := 2;
 l_tbl('c') := 3;

 l_tbl.delete('b');

 l_tbl('e') := 4;

 l_key := l_tbl.first;

 LOOP
   EXIT WHEN l_key IS NULL;
   dbms_output.put_line(l_tbl(l_key));
   l_key := l_tbl.next(l_key);
 END LOOP;

END;


Entries and comments feeds.