[Tickets #598] NEW: Oracle SQL scripts contain blanklines in SQL statements

[bugs at bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/?id=598
-----------------------------------------------------------------------
 Ticket     | 598
 Created By | rvs at angara.ru
 Summary    | Oracle SQL scripts contain blanklines in SQL statements
 Queue      | Horde Base
 Version    | HEAD
 State      | Unconfirmed
 Priority   | 1. Low
 Type       | Bug
 Owners     | 
-----------------------------------------------------------------------


rvs at angara.ru (2004-09-16 11:22) wrote:

Platform: Apache1.3.31+php4.3.8+Oracle9.2.0.1

File horde/scripts/db/oracle_create.sql,v 1.6.
The table creation scripts for Oracle contain blanklines before
PRIMARY KEY clause.
The SQLPLUS utility on Oracle9.2 doesn't like this by default because the
SQLBLANKLINES parameter defaults to OFF.

Suggest adding "set sqlblanklines on;" at the script start for seamless
table creation.
Note: this issue is applicable for other applications, such as Turba, Whups
etc.