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

Maggie <maggiezhou_at_hotmail.com> schrieb in im Newsbeitrag: 8t7uc5$bs2$1_at_web1.cup.hp.com...

> 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'

Hi Maggie,

dbms_output.put_line will not accept a complete record(-variable) as parameter. Try something like this:

dbms_output.put_line( v_r11.field1 || ';' || v_r11.field2 || ';' || v_r11.field3 );

regards

Holger Kreft Received on Thu Oct 26 2000 - 01:54:44 CDT