Parantheses error in Select statement.

[NitinJain]

Hello!

I have executed the following code without any errors in Oracle8, but give an error related to the parantheses when executed in oracle 9i.

CODE::::
...
...
...
SELECT (NodeType = 3 OR NodeType = 4 OR NodeType = 8)?????
INTO nodeIsText
FROM t_Node
WHERE id = thisNode;
....
....
....

Can any one please suggest something on this.

Regards.

Nitin

 

[Swany]

you can use my suggestion in the other post you made
or change your SQL to:

select 'TRUE' into nodeIsText
from t_Node
where id=thisNode
and (NodeType = 3 OR NodeType = 4 OR NodeType = 8);

.
.. Eat, think and be merry .
... ....................... .