Differences

This shows you the differences between two versions of the page.

--- v5:database:oracle [2022/02/14 22:32] – [Session Mode] dregad
+++ v5:database:oracle [2023/01/25 04:40] (current) – [Auto-Increment Column] mnewnham
@@ Line 14: / Line 14: @@
 == Alternatives ==
 [[v5:database:pdo#pdo_oci|PDO driver for Oracle]]
+== See Also ==
+[[v5:reference:connection:setconnectionparameter#oracle|setConnectionParameter()]]
 </WRAP>
@@ Line 90: / Line 92: @@
 ==== Auto-Increment Column ====
 [[v5:dictionary:column_attributes#AUTO or AUTOINCREMENT|Auto-increment]] support for Oracle databases is implemented by creating an on-insert trigger that retrieves a sequence number from a sequence //**SEQ_ + table name **//. This is done by default.
+If you have long table names then the generated trigger name can exceed the maximum allowed length. To prevent this, use the class variable ''useCompactAutoIncrements''. This will change the trigger name to a generated CRC value of the name.
+=== Example using the table name "customer_delivery_address" ===
+By default, the trigger name would be SEQ_CUSTOMER_DELIVERY_ADDRESS which exceeds the 16 character name for sequences. By setting ''$db->useCompactAutoIncrements=true'', the sequence name is changed to ''SEQ_401703491''
+=== Accessing the trigger in your code ===
+<code php>
+$db->useCompactAutoIncrements=true;
+$tab = 'customer_delivery_address';
+$tab = sprintf('SEQ_%u',crc32(strtolower($tab)));
+print $tab; //prints SEQ_401703491
+</code>
 -----------------------------------
 ==== Session Mode ====