SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Convert Java.lang.string to CLOB in Function

585867Jul 2 2007 — edited Jul 2 2007

I am facing problem while converting Java.Lang.String to oracle.sql.clob. I am using Java class in Oracle 8i. Java Class returns a string to the stored procedure. The problem arises when a LARGE string is returned.

FUNCTION CallService(Param1 VARCHAR2, Param2 VARCHAR2, Param3 VARCHAR2)
return varchar
AS

LANGUAGE java
NAME 'BizTalkService.CallService(java.lang.String, java.lang.String, java.lang.String) return java.lang.String';

end;

I need a ‘return CLOB’ instead of ‘return java.lang.string’.

Can someone please help me?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 30 2007

Added on Jul 2 2007

4 comments

722 views