Re: Calculating Boolean

Hi.

[Quoted] I've used DBMS_SQL to evaluate expressions that can return a value in SQL ('SELECT ' || my_expr || ' FROM dual').

But Booleans are not a SQL datatype (can't do 'SELECT TRUE from dual'), which poses a problem. I hate to suggest this (because it's awkward and pokey), but perhaps you could use DBMS_SQL to create a temporary packaged function that analyzes your expr and returns a numeric (say, 0 for False, 1 for true). You could then use DBMS_SQL to query DUAL and return an integer value from your temporary function.

Does 8i offer you any relief?

-John

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!