[Solar-talk] Oracle Update

[Paul M Jones]

Hi everybody,

I've incorporated James Kilbride's Solar_Sql_Adapter_Oracle into the  
core.  If you're an Oracle user, please try it out and let us know how  
it works for you.  Some changes to it may be forthcoming, especially  
in reference to the following points:

* Should we make the (create|drop)Sequence() methods always add  a  
"_seq" suffix to the sequence name?

* Should we set NLS format to ISO 8601 as part of post-connect? E.g.,
   ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS'

* Something about how NULLs get returned?  Need to make sure NULLs are  
not merely empty strings, or something. Cf. the PDO::ATTR_ORACLE_NULLS  
note here: <http://us.php.net/manual/en/pdo.setattribute.php>

* Because (most? all?) other DBs with auto-increment allow only one  
autoinc per table, should the sequence/trigger names be on the table  
name and not the column name? Keying on col name means that IDs will  
be GUIDs, not table IDs. That's not bad, exactly, but it might not be  
the expected behavior.


-- pmj