Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> How can I output the content in a variable from dbms_output.put_line

How can I output the content in a variable from dbms_output.put_line

From: Maggie <maggiezhou_at_hotmail.com>
Date: Wed, 25 Oct 2000 17:37:21 -0700
Message-ID: <8t7uc5$bs2$1@web1.cup.hp.com>

In one part of my PLSQL, I try to watch the output from a variable when I loop each time:

select * into v_r11

    from orders
    where product_line_cd = '719D';

dbms_output.put_line( v_r11);

However, I got error message:
PLS-00306: wrong number or types of arguments in call to 'PUT_LINE'

Please help. Received on Wed Oct 25 2000 - 19:37:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US