Re: Package problem

Rob,

You need to assign the returning varchar2 as per your function definition. I assume that as you have declared the purity of your function with restrict_references, you want to use the function in a sql statement. The following will work.

1. In a sql statement

select get_next_vrd_pkg.next_vrd_number('us','a') from dual;

2. In an anonymous PL/SQL block
declare

    str_ret varchar2(255);
begin

    str_ret := get_next_vrd_pkg.next_vrd_number('us','a');     dbms_output.putline('str_ret'||str_ret); end;

Chris Received on Tue Jan 12 1999 - 16:48:23 CST