For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
BOOLEAN is available in PL/SQL but not in SQL.
This request is now referenced as: Enh 28146286 - SUPPORT FOR ISO SQL BOOLEAN DATA TYPE
It's funny that the day before, I get stumped by a problem the whole day... then the next day I find the answer to my problem.
The view is actually working. but the last record is not appearing. This is the same for my tables. no last record.
I get 3 rows in the table in the SQL Command Line.
I get 2 rows in the view in the SQL Command Line.
I get 2 rows in the table in the PHP Web page.
I get 1 row in the view in the PHP Web page.
I have only changed the select statement, the rest of the code is the same.
help?
OK, I have just figured it out.
Oracle 11g XE allows for one session. Connecting to Oracle through PHP counts as a session.
Disconnecting the console fixed the problem.
You can have more than one session at a time to XE. At a guess, you hadn't committed in the first session and disconnecting performed the commit for you. This let the other session see the data.