[ic] oracle - country import failed

[Jon August]

When I try to start interchange using Oracle I get this error:

----------------------------------------------------------
[www] ~ (517) sudo  su -c "/usr/local/interchange/bin/interchange
-r" interchange
Password:
Killing Interchange server 23270 with TERM.
Low traffic settings.
Calling UI......UI is loaded...
Interchange V4.8.3
Configuring catalog trimspa...Using Oracle, DSN=dbi:Oracle:itst...table
country created: create table country ( 
code VARCHAR2(3) PRIMARY KEY,
sorder VARCHAR2(128),
region VARCHAR2(128),
selector VARCHAR2(3),
shipmodes VARCHAR2(64),
name VARCHAR2(32) DEFAULT '',
iso CHAR(3) DEFAULT '' NOT NULL,
isonum CHAR(3) DEFAULT '' NOT NULL,
tax VARCHAR2(128)
)

table 'country' failed: country import failed: ORA-01400: cannot insert
NULL into ("XXXXXX"."COUNTRY"."ISO") (DBD ERROR: OCIStmtExecute)

done.
Interchange server started in INET and UNIX mode(s) (process id 23790)
[www] ~ (518) 

---------------------------------------------------------

XXXXXX is replaced by the Oracle username.  Also, the checkout gives an
Internal Server Error. 

This shows up in the error.log:

-------------------------------------------------------
[09/February/2002:02:36:19 -0500] xxxxxx /xxxxxx.cgi/process.htm
l Safe: Can't locate DBI object method "quote" via package
"DBD::Oracle::db" at /usr/local/interchange/lib/
Vend/Table/DBI.pm line 602.
> 
> 
>       my $db = $Db{cat} || return;
>       my $settor = $db->field_settor('sort');
>       foreach ( @{ $Scratch->{cat_sort} } ) {
>               $settor->( @$_ );
>       }
>       delete $Scratch->{start_sort};
>       return;
> 
------------------------------------------------------

Any ideas



	-Jon

---                   
Voice: (973) 560-9095  | Internection - Electronic Commerce, Internet
Cell : (973) 801-6071  | Consulting and Grade A Web Hosting Since 1995.