[Openinteract-dev] Re: [Openinteract-help] OI on Oracle

[Chris W. <ch...@cw...>]

On Tue, 2002-03-26 at 13:05, Ben Avery wrote:
> I'm going ahead with using OI on this project, but need to use it with
> Oracle (8i Enterprise). 
> I understand SPOPS itself is okay with Oracle, but not OI yet. Is that
> right?
> I'm happy to do the work necessary to port OI to Oracle, but might need a
> little help, as I don't have too much surplus time on this project.

Excellent. These things always go much quicker when someone actually
needs to get something done :-)

> I've been looking through the files in the website I've created with
> oi_manage, to identify pieces of code which will need modification. The SQL
> in the .sql files in /struct dirs mostly won't work with Oracle, these will
> be easy to convert, however.

It would be great if you kept the converted files around -- we can
easily just make them part of the packages that get used for oracle
installs. In addition to the varchar -> varchar2 (etc.) issues, we'll
need to create files for the different sequences to create as well.
Easy.
 
> Could you help me identify any other places where DB-specific code is
> located, and any new modules that will need to be created to handle
> Oracle-specific code, and even any considerations you've come across in
> porting OI between DBs?

I'll need to noodle over this a little bit. I seriously doubt we need to
create any new modules, but that's just a first glance at the issue.

The only issues with porting OI across DBs have generally been small
things -- this database doesn't like 'NOT NULL' used with 'DEFAULT',
that database requires 'NOT NULL' to be used with 'DEFAULT' if a field
is used in a UNIQUE index. Annoying stuff :-)

Chris

-- 
Chris Winters (ch...@cw...)
Building enterprise-capable snack solutions since 1988.