Re: What's wrong with my PLSQL Function?

In article <f5042544.0304222234.51fb0a93_at_posting.google.com>, v_dh_at_hotmail.com says...
> Hi all,
>
> I'm learning in PL/SQL.
> I create a little PLSQL block (disp_chars.sql) to execute the function
> f_line() as below:
>
>
> disp_chars.sql
> ==============
> set serveroutput on
> set verify off
>
> CREATE OR REPLACE FUNCTION f_line (v_number in INTEGER, v_character in
> VARCHAR2)
> RETURN VARCHAR2
> IS
> v_line VARCHAR2(80) := '';
>
> BEGIN
>
> WHILE v_num > 0 LOOP
> v_line := v_line + v_character;
> v_num := v_num - 1;
> END LOOP;
>
> RETURN v_line;
>
> END;
> /
> Declare
> v_num INTEGER;
> v_char VARCHAR2(1);
> v_result VARCHAR2(80);
> Begin
> v_num := &number;
> v_char := '&character';
>
> v_result := f_line(v_num,v_char);
>
> dbms_output.put_line(v_result);
>
> end;
>
> --------------------------------------------------------------------
>

Try it this way:

 SELECT f_line(v_num,v_char)
   INTO v_result
   FROM dual;

• Tom