Details
-
Bug
-
Resolution: Fixed
-
Medium
-
extension/ezoracle 2.0.3
-
None
-
Operating System: RHEL 5
PHP Version: 5.3
Database and version: Oracle Database 10g Release 10.2.0.4.0 - 64bit Production
Browser (and version): n.a.
Description
In the file dbupdate-4.2.0-to-4.3.0.sql of the ezoracle extension there are two errors:
The block starting on the lines 11 to 21 is errorneous.
I altered it from
CREATE TABLE ezscheduled_script ( id INTEGER NOT NULL, process_id INTEGER DEFAULT 0 NOT NULL, name VARCHAR2(50) NOT NULL, -- default '' command VARCHAR2(255) NOT NULL, -- default '' last_report_timestamp INTEGER DEFAULT 0 NOT NULL, progress INTEGER DEFAULT 0, user_id INTEGER DEFAULT 0 NOT NULL, PRIMARY KEY (id), INDEX ezscheduled_script_timestamp (last_report_timestamp) );
to
CREATE TABLE ezscheduled_script ( id INTEGER NOT NULL, process_id INTEGER DEFAULT 0 NOT NULL, name VARCHAR2(50) NOT NULL, -- default '' command VARCHAR2(255) NOT NULL, -- default '' last_report_timestamp INTEGER DEFAULT 0 NOT NULL, progress INTEGER DEFAULT 0, user_id INTEGER DEFAULT 0 NOT NULL, PRIMARY KEY (id) ); CREATE INDEX ezscheduled_script_timestamp ON ezscheduled_script (last_report_timestamp) ;
- else a error ist thrown by our Oracle 10g.
Additionally there is a missing semicolon on line 23:
CREATE SEQUENCE s_scheduled_script
should be
CREATE SEQUENCE s_scheduled_script;
.