Re: Simple question..I am running a stored procedure from SQL PLUS

Could be a couple of things but one of the most likely is that the value you are feeding to DBMS_OUTPUT is null. When DBMS_OUTPUT gets a null it doesn't print anything. Try wrapping your input to DBMS_OUTPUT with the NVL function

i.e.

DBMS_OUTPUT.PUT_LINE(NVL(my_varchar2,'NULL VALUE'));

Hope this helps
RHC
Manoj Nair wrote:
>
> so i do a SQL> EXEC my_sp..I have dbms_output statements in code and i
> have also set serverout on ..but it doesn't print the messages what am
> i missing?

--
Posted via CNET Help.com
http://www.help.com/