JDBC to read and write CLOB
Creating a Test Table create table CLOB_TEST (ID number (10), CLOB_TEXT CLOB)
getconnection
JDBC oracle Hello World
Ojdbc14.jar should first added to the reference library Output EMPNO ENAME 7369 SMITH 7499 ALLEN 7521 WARD 7566 JONES 7654 MARTIN 7698 BLAKE 7782 CLARK 7788 SCOTT 7839 KING 7844 TURNER 7876 ADAMS 7900 JAMES 7902 FORD 7934 MILLER
[Original] allows you to Oracle stored procedure to interact with Java code to the beginning
rn Oracle stored procedure definition format is as follows: rn rn rn rn rn rnrnrn CREATE OR REPLACE PROCEDURE PRO_YOUR_PROCEDURE ( rn ELEMENT_01 IN ELEMENT_TYPE, - COMMENTS rn ....... .... ..... .... rn ELEMENT_0S OUT ELEMENT_TYPE, - COMMENTS rn .... ...