this is related to
java stored procedure
i get the error
ORA-06502: PL/SQL: numeric or value error: character
string buffer too small
when running the following procedure
variable a1 varchar2
exec call_func(:a1)
procedure call_func(p_name out char)
as
begin
p_name:=oscar_quote();
end;
FUNCTION oscar_quote RETURN varchar2
AS LANGUAGE JAVA
NAME 'Oscar.quote() return java.lang.char';
public class Oscar
{
public static String quote()
{
return "Hello how do you do";
}
}