How to Read DBMS_OUTPUT from a stored procedure in a java program

[Praveena Surapaneni]

Hi All

I am wondering if we can read the DBMS_OUTPUT from a stored procedure in a java program. If so, how?

Thanks
Praveena

[Avi Abrami]

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").

Good Luck,
Avi.

[Praveena Surapaneni]

Thanks Avi

[Srinivasa Raghavan]

Originally posted by Praveena Surapaneni:
Thanks Avi

Yes as Avi said use a out parameter in oracle Sp

[Avi Abrami]

Srini,

Avi said use a out parameter in oracle Sp

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.

[Srinivasa Raghavan]

Originally posted by Avi Abrami:
Srini,

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 ]

[Avi Abrami]

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.

Good Luck,
Avi.

[Srinivasa Raghavan]

ok.
Where to use a Pl/SQL function & where to use a OutParameter
Any Idea on it ?
Does it make any differnece on the execution time ?

[Avi Abrami]

Srini,
I use OUT parameters when I need to return more than one value from a (PL/SQL) routine -- since a function can only return one value.

If I only return one value, then I prefer to use a function.

I don't know if there's a performance difference between using OUT parameters or functions.

Good Luck,
Avi.

[Srinivasa Raghavan]

Originally posted by Avi Abrami:
Srini,
I use OUT parameters when I need to return more than one value from a (PL/SQL) routine -- since a function can only return one value.

If I only return one value, then I prefer to use a function.

I don't know if there's a performance difference between using OUT parameters or functions.

Good Luck,
Avi.

Humm Thanks Avi..