Re: stored function problem

River wrote:
> rcontent char;

The rcontent variable has length 1.

> table: secret ( code varchar2(8),
> content varchar2(10) )

The content column has length 10.
So you can´t assign the column to the variable. Solution:
declare the rcontent variable with length 10. rcontent char(10); or
rcontent varchar2(10); and the better solution rcontent secret.content%type;

-- 
+-------------------------------+----------------------------------+
| Dyrson Rodrigues Alves Junior | Casa de Software                 |
| Analista de Sistemas          | Oracle Approved Education Center |
| mailto:dyrson_at_casasoft.com.br | http://www.casasoft.com.br       |
+-------------------------------+----------------------------------+