ORA-06502 error when returning varchar2...

From: buu <aha_at_a.com>
Date: Sat, 8 Mar 2008 23:42:40 +0100
Message-ID: <fqv4os02vti@enews2.newsguy.com>

I have an procedure with an query like:

function aa() return varchar2 as

update table1

   set field_1='xxx'
  where id=1
 returning field_2 into v_retval:

return v_retval;

I'm handling that simple function in vb.net 2005. But, in vb.net I receive an ORA 6502 error.. why? fileld size is not a problem. Received on Sat Mar 08 2008 - 16:42:40 CST

Original text of this message