From 0513f3bfa526dec212d95ff0a55d6b25b665d66b Mon Sep 17 00:00:00 2001 From: stronk7 Date: Sun, 20 Aug 2006 21:56:54 +0000 Subject: [PATCH] $statement_end for Oracle changed to "/" because standard ; causes problems with trigger generation --- lib/xmldb/classes/generators/oci8po/oci8po.class.php | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) diff --git a/lib/xmldb/classes/generators/oci8po/oci8po.class.php b/lib/xmldb/classes/generators/oci8po/oci8po.class.php index e0951a9c47..0aaef00ffc 100644 --- a/lib/xmldb/classes/generators/oci8po/oci8po.class.php +++ b/lib/xmldb/classes/generators/oci8po/oci8po.class.php @@ -32,6 +32,9 @@ class XMLDBoci8po extends XMLDBgenerator { /// Only set values that are different from the defaults present in XMLDBgenerator + var $statement_end = "\n/"; // String to be automatically added at the end of each statement + // Using "/" because the standard ";" isn't good for stored procedures (triggers) + var $number_type = 'NUMBER'; // Proper type for NUMBER(x) in this DB var $unsigned_allowed = false; // To define in the generator must handle unsigned information @@ -135,7 +138,7 @@ class XMLDBoci8po extends XMLDBgenerator { $trigger.= "\n FOR EACH ROW"; $trigger.= "\nBEGIN"; $trigger.= "\n SELECT " . $sequence_name . '.nextval INTO :new.' . $this->getEncQuoted($xmldb_field->getName()) . " FROM dual;"; - $trigger.= "\nEND"; + $trigger.= "\nEND;"; return array($sequence, $trigger); } -- 2.39.5