Pass large amounts of text to a stored procedure written in java

[mjkelly]

Hi,
I have a stored procedure written in java in an Oracle 10g db.
This sp takes a java.lang.String as input, creates a file on disk and writes the string contents to it and inserts the filename (plus some other data) in a table in the database and returns the newly generated primary key (as a java.lang.Integer). The call spec defines the input parameter as a LONG.
I have also written a java client app to test this and it works fine up to a point.
The point being that if I try to pass a String longer than 32512 bytes I get an ORA-01460 error (unimplemented or unreasonable conversion requested).

What I would like to know is whether it is actually possible to pass very large text strings to a stored procedure written in java and, if so, how should I go about doing it?

Many thanks.

[pragatiswain]

Hi,
I have a stored procedure written in java in an Oracle 10g db.
This sp takes a java.lang.String as input, creates a file on disk and writes the string contents to it and inserts the filename (plus some other data) in a table in the database and returns the newly generated primary key (as a java.lang.Integer). The call spec defines the input parameter as a LONG.
I have also written a java client app to test this and it works fine up to a point.
The point being that if I try to pass a String longer than 32512 bytes I get an ORA-01460 error (unimplemented or unreasonable conversion requested).

What I would like to know is whether it is actually possible to pass very large text strings to a stored procedure written in java and, if so, how should I go about doing it?

Many thanks.

Actually, Oracle String (Varchar2) should support upto 4000 bytes in Oracle 8i/9i.
Why not break the large string (each part not exceeding 32512 bytes as per you) and pass it to the SP in a loop?