hi guys
i;m reading long raw from db in a
Java class. its reading fine and working ok. now i have uploaded this class into oracle using "uploadjava " command and calling this using oracle function:
CREATE OR REPLACE FUNCTION concatFile
(docNo in number,sectionCd IN VARCHAR2)
RETURN VARCHAR2
AS LANGUAGE JAVA
NAME 'Concat.concatFiles(int,java.lang.String)
return java.lang.String';
whts happening here now it doesnt read the "long raw" col if the data in it is >= 32k. i dont know whts happening? becaz whn i excute the same java class independtly its working fine. but whn i run it thru Oracle Function (aftering inserting java class into oracle) i'm facing this problem.
might be i have to set some oracle setting to let it read more then 32k chunk internally???anybody any idea? any help/idea/suggestion woudl be realy appriciated
rgds
