Boolean Function Problem. 
Author Message
 Boolean Function Problem.

Quote:
>MOORE WROTE:
>Oh please help me!

>What is wrong?

>SQL> CREATE OR REPLACE
>  2  FUNCTION FOO RETURN BOOLEAN IS
>  3  BEGIN
>  4   RETURN TRUE;
>  5  END FOO;
>  6  /

>Function created.

>SQL> select foo from dual;
>ERROR:
>ORA-06550: line 1, column 12:
>PLS-00382: expression is of wrong type
>ORA-06550: line 1, column 7:
>PL/SQL: Statement ignored

>no rows selected

>Hi,

There is no Boolean datatype in oracle. Just PL/SQL
Sandy

- Show quoted text -



Wed, 18 Jun 1902 08:00:00 GMT
 Boolean Function Problem.

boolean is pl/sql only, you CAN'T use it in ordinary sql, so not in function
returns.

Hth,

Sybrand Bakker, Oracle DBA


Quote:
> Oh please help me!

> What is wrong?

> SQL> CREATE OR REPLACE
>   2  FUNCTION FOO RETURN BOOLEAN IS
>   3  BEGIN
>   4   RETURN TRUE;
>   5  END FOO;
>   6  /

> Function created.

> SQL> select foo from dual;
> ERROR:
> ORA-06550: line 1, column 12:
> PLS-00382: expression is of wrong type
> ORA-06550: line 1, column 7:
> PL/SQL: Statement ignored

> no rows selected



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Aggregate functions on boolean column

2. how to create a boolean function?

3. User defined Function with boolean parameter

4. Boolean function for ADO

5. Function fails to return boolean

6. Boolean Function in SQL

7. Calling a stored function that returns a boolean and two OUT parameters

8. Q: Pro*C and a PL/SQL function returning BOOLEAN

9. Functions and Boolean datatype

10. BOOLEAN parameter passed to a stored function

11. boolean (bit) problem


 
Powered by phpBB® Forum Software