USING BOOLEAN FUNCTION

[prosuc]

How I can use a function that return a boolean value in a SELECT sentence????

I try the following:

SELECT * FROM table_name
WHERE boolean_function_call(parameter);

the function must be return TRUE.

Oracle send me the following message:

ERROR at line 1:
ORA-00920: invalid relational operator

my database version is Oracle8i Enterprise Edition Release 8.1.7.0.0

 

[sem]

Oracle SQL doesn't support BOOLEAN datatype.

Regards, Dima

 

[prosuc]

thanks Dima.