Re: (*long*) Re: Package procedure call from forms

In article <3a05jk$a1m_at_fred.uswnvg.com> mmcgreg_at_pebbles.uswnvg.com (Mark McGregor) writes:
>
>In my experience, SQL*Forms 3.0 DOES NOT correctly support the BOOLEAN
>return type when interfacing with PL/SQL 2.0. Perhaps this is a port
>specific BUG, perhaps not. Here is a simple test. Create a function
>as follows:
>
>CREATE OR REPLACE
>FUNCTION BUGFUNC ( ival IN char ) RETURN BOOLEAN
>IS
>BEGIN
>return FALSE;
>END;
>
>As you can see, this function ALWAYS returns FALSE. However, when I call
>it from a form (3.0) it always returns TRUE. A miracle. Or perhaps a bug.

It's a known bug. It always returns TRUE, and so you can't use BOOLEAN. The last time I heard there was no patch for SQL*Forms 3. A workaround was to use INTEGER.

-- 
							Yoichi Tamura
							y-tamura_at_nri.co.jp