Praveena, As far as I know, you cannot read the output from DBMS_OUTPUT in a java program.
Perhaps try creating a PL/SQL function that returns the string you are trying to read. That's something you can obtain from a java program (using the "execute()" method in "java.sql.CallableStatement").
No, I did not suggest using an OUT parameter in an Oracle stored procedure, I suggested using an Oracle stored function. I do believe that the two are different.
Good Luck, Avi.
Oh ! i'm sorry Avi, i mis-understood it .. What about out parameter ? Is it not a good design ? Please throw some light on it. Also Avi, if possible Can you guide me Here. [ January 01, 2005: Message edited by: srini vasan ]
Srini, I believe there are situations where OUT parameters are a "good design" (as you put it). However, based on the information that Praveena has supplied, I think that a (PL/SQL) function is more appropriate.