/*
 ** +----------------------------------------------+
 ** | EXAMPLE: #1                                  |
 ** | -------------------------------------------- |
 ** | The following example will create a sample   |
 ** | table, populate it with values, query the    |
 ** | sample table using both "normal" and         |
 ** | "scrollable" cursors, delete all sample data |
 ** | and finally drop the table.                  |
 ** +----------------------------------------------+
*/

CONNECT jserver_demo/jserver_demo

SET SERVEROUTPUT ON
CALL dbms_java.set_output(5000);

CALL JServer_mgr.create_tables();

CALL JServer_mgr.insert_values(100, 'James Smith', null);
CALL JServer_mgr.insert_values(101, 'Amy Miller', null);
CALL JServer_mgr.insert_values(102, 'Andy Phillips', null);
CALL JServer_mgr.insert_values(103, 'Jimmy Black', null);
CALL JServer_mgr.insert_values(104, 'Jane Dee', null);

CALL JServer_mgr.query_forward();
CALL JServer_mgr.query_reverse();

CALL JServer_mgr.delete_values();

CALL JServer_mgr.drop_object ('TABLE', 'JSERVER_DEMO_TABLE');