How to Insert String to LVARCHAR

[Hobby]

Hi,

I have the following stored procedure

CREATE PROCEDURE SEARCH_CRUISE_DEBUG33(
)
RESULT (
CruiseId VARCHAR(10000)
)

BEGIN
String resultString = null ;
// Businees logic to populate resultString.
SQLResultSet.set(1, resultString);
SQLResultSet.insert();

END


The length of resultString is very large. Hence i got exception at SET statement.

What is the solution for this.

I tried giving LVARCHAR in the result. But in this case when i display the output, its always <null>