I have this table:
CREATE TABLE SCOTT.san_clob_blob
id NUMBER NOT NULL,
CONSTRAINT PK_san_clob_blob PRIMARY KEY (id)
I have created this PL/SQL Stored Proc in Oracle9i:
CREATE OR REPLACE procedure san_clob_insert (rid in number,clob_data in clob) as
select clob_field into dest_var from san_clob_blob where id = rid for update;
I then created a JDBC Adapter Service for the above stored proc and gave PARAM JDBC Type as “NUMERIC” for rid and “CLOB” for clob_data; and made both input types as java.lang.String.
But when I am trying to insert bulk clob data (string of size say 100kb) through the same I am getting this error: “ORA-01460: unimplemented or unreasonable conversion requested”.
But when I execute the same for little clob data (string such as “This is a sample string”) it gets appended perfectly.
Can someone help me with this???
-Mahidhar, Bangalore (India)