Re: Problem in using Stored Function in SQL statement

From: Howard Gluckman <hgluckm_at_uswesst.com>
Date: 1997/04/16
Message-ID: <33553245.A08_at_uswesst.com>#1/1

Albert Lam wrote:
> I have this stored function on the server : IS_STATUS_ACTIVE()
> This function should return BOOLEAN result.
>
> <snip>
>
> PLS-00425: in SQL, function argument and return types must be SQL
> type.
>
> Does anyone have any idea ?
>
> Thanks
A PL/SQL function used in a SQL statement must return a data type that SQL can use (e.g., NUMBER, CHAR, VARCHAR2, DATE). BOOLEAN is not one of those data types.

-- 
Howard Gluckman
Data Architect
U S WEST Communications
hgluckm_at_uswest.com

Any opinions are personal, and do not represent U S WEST Communications.

Received on Wed Apr 16 1997 - 00:00:00 CEST

This message: [ Message body ]
Next message: Evelyn Gonzalez: "Thoughts needed: VB5.0 and ORACLE NT"
Previous message: Dmitry L. Zhuk: "Re: Forms 4.5: Enabling Button Triggers in Query Mode"
In reply to: Albert Lam: "Problem in using Stored Function in SQL statement"
In reply to Albert Lam: "Problem in using Stored Function in SQL statement"
Next in thread: Dave Schweisguth: "PL/SQL call graph generator?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message