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

Mark McGregor (mmcgreg_at_pebbles.uswnvg.com) wrote:

... stuff deleted ...

: 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.
 

: Here are the specs for the form stuff that I am running. This is on a
: Sequent computer.
 

: SQL*Forms Run Form: Release 3.0.16.12.7 - Production
: Oracle7 Server Release 7.1.3.0.0 - Production Release
: PL/SQL Release 2.1.3.0.0 - Production
: Using Oracle Toolkit Version 01.00.20.03.01 (Production)
: Using PL/SQL Version 01.00.39.00.01 (Production)
 

: I have also tested this on another release of the tools which is more
: current and it has the same problem:
 

: Using Oracle Toolkit Version 01.00.20.03.01 (Production)
: Using PL/SQL Version 01.00.42.00.01 (Production)
 

: Any comments? Has anyone else seen this happen?
 

: --
: Mark McGregor mmcgreg_at_uswnvg.com
 

: ** I try to speak only for myself, so that my foot doesn't end up in **
: ** someone else's mouth **

Yes, I've experienced the same problem running:-

SQL*Forms Run Form: Release 3.0.16.12.7
Oracle7 Server Release 7.0.15.4.0 (on Sun-OS 4.1.3)
Oracle7 Server Release 7.0.16.4.0 (on Solaris 2.3)

I was hoping that the problem might be fixed in a later release, but I guess not yet!

Interesting to note that calling the function from within PL/SQL 2.0 works fine, therefore I can only assume that SQL*Forms 3.0 is the problem.

-- 
Jill Stephenson - Tortuga Technologies Pty Ltd

jill_at_ziggi.brisnet.org.au