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

:    (*) SUPPORTED DATATYPES FOR


:        PARAMETERS & FUNCTION RETURN VALUES


:        ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

:        Stored Procedures, Functions, and Packages are created using version

:        2.0 of PL/SQL within the Oracle7 database. Since SQL*Forms 3.0 is

:        built on PL/SQL version 1.0, for backward compatibility reasons only

:        the following PL/SQL 2.0 datatypes are supported for Parameters and

:        as Function Return values.

 


:                 VARCHAR2   -- Maximum of VARCHAR2(2000)


:                 NUMBER

:                 DATE

:                 BOOLEAN


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                                              **