From 465a8029378e8bd5fc7b7b15d2864db2cb169019 Mon Sep 17 00:00:00 2001 From: stronk7 Date: Sat, 19 Aug 2006 00:58:30 +0000 Subject: [PATCH] Thought this was commited. Solve one bug in trigger generation --- lib/xmldb/classes/generators/oci8po/oci8po.class.php | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) diff --git a/lib/xmldb/classes/generators/oci8po/oci8po.class.php b/lib/xmldb/classes/generators/oci8po/oci8po.class.php index 6fa0195919..e0951a9c47 100644 --- a/lib/xmldb/classes/generators/oci8po/oci8po.class.php +++ b/lib/xmldb/classes/generators/oci8po/oci8po.class.php @@ -120,8 +120,9 @@ class XMLDBoci8po extends XMLDBgenerator { */ function getCreateSequenceSQL ($xmldb_table, $xmldb_field) { - $sequence = "CREATE SEQUENCE "; - $sequence.= $this->getNameForObject($xmldb_table->getName(), $xmldb_field->getName(), 'seq'); + $sequence_name = $this->getNameForObject($xmldb_table->getName(), $xmldb_field->getName(), 'seq'); + + $sequence = "CREATE SEQUENCE " . $sequence_name; $sequence.= "\n START WITH 1"; $sequence.= "\n INCREMENT BY 1"; $sequence.= "\n NOMAXVALUE"; @@ -133,7 +134,7 @@ class XMLDBoci8po extends XMLDBgenerator { $trigger.= "\nON " . $this->getEncQuoted($this->prefix . $xmldb_table->getName()); $trigger.= "\n FOR EACH ROW"; $trigger.= "\nBEGIN"; - $trigger.= "\n SELECT " . $trigger_name . '.nextval INTO :new.' . $this->getEncQuoted($xmldb_field->getName()) . " FROM dual;"; + $trigger.= "\n SELECT " . $sequence_name . '.nextval INTO :new.' . $this->getEncQuoted($xmldb_field->getName()) . " FROM dual;"; $trigger.= "\nEND"; return array($sequence, $trigger); } -- 2.39.5