Re: [Openinteract-help] Oracle DB setup problems

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

On Mon, 2002-03-18 at 13:27, Ben Avery wrote:
> does anyone have experience of setting up OI on Oracle?
> 
> I am still working through the 'fruit' test package, but cannot manage to
> build a database table.
> this is the output from the test_db stage:
> 
> /export/home/oi_dev/fruit $ oi_manage --package fruit test_db
> 
> [oi_manage]: Using (/export/home/openinteract) for 'base_dir'.
> [oi_manage]: Using (/export/home/cares/test) for 'website_dir'.
> Running test_db...
> =========================
> 
> DBD::Oracle::db do failed: ORA-00900: invalid SQL statement (DBD ERROR:
> OCIStmtExecute) at /usr/local/lib/perl5/site_perl/5.6.1/OpenInteract/DBI.pm
> line 47.
> Status of the database test:
> 
> FAILED!: 
>            Status of connection <<main>> (default
>            connection) 
>            =========================
>            -- Basic connect: ok
>            -- Use database: failed -- ORA-00900: invalid
>            SQL statement (DBD ERROR: OCIStmtExecute)
>            -- Create table: not attempted
> 
> =========================
> Finished test_db!
> 
> the table SQL is:
> 
> /export/home/oi_dev/fruit $ cat struct/create-table-fruit.sql   
> create table fruit (
> id NUMBER(10),
> name VARCHAR2(255),
> taste VARCHAR2(255),
> price VARCHAR2(255)
> )
> 
> this SQL creates the table with no problems in SQL*PLUS.
> 
> does anyone have any ideas? do I have to format or terminate the SQL in a
> certain way?

Unfortunately you're going to be a bit of a guinea pig here, since I've
never installed OI on Oracle before.

However, you can probably get around this error by leaving the
'db_info.main.db_name' key empty in the server configuration. IIRC,
Oracle generally specifies this in the DSN or an environment variable,
so you don't need to do so.

Chris

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