[imp] Pear 4.1.0 available at http://www.horde.org/pear/ does not work with Oracle

Miguel Ward mward@aluar.com.ar
Fri, 21 Jun 2002 08:51:25 -0300

This is a multi-part message in MIME format.

---------------------- multipart/mixed attachment

Oracle does not support more than 4000 bytes per string, you get an 'ORA-01704:
string literal too long'.

Until Oracle fixes this (or php/PEAR provide a workaround for this Oracle
limitation) there is no way you can send a string longer than this in one
operation. In my script just the same I use CLOBS hoping that in the future this
limitation is fixed. You can easily try this limitation by trying to save a
large 'signature'. Your /tmp/horde.log will report this error and you will get a
'DB Error: unknown error' at line 297 on screen.

I include my sql script to create horde and turba tables in Oracle with these
comments included as well as other pertinent instructions.

If you see any mistakes (or have additional comments) please let me know.


----- Original Message -----
From: "Liam Hoekenga" <liamr@umich.edu>
To: <imp@lists.horde.org>
Sent: Friday, June 21, 2002 1:43 AM
Subject: Re: [imp] Pear 4.1.0 available at http://www.horde.org/pear/ does not
work with Oracle

Hey Miguel -

Do you use "clobs" for columns that would be mysql "text", or do you use
varchar2(4000)s?  We're using varchar2(4000)s, but have found situations
where those columns are getting filled (ie w/ people who *really* like
filter rules)...


On Thu, 20 Jun 2002, Chuck Hagenbuch wrote:

> Quoting Miguel Ward <mward@aluar.com.ar>:
> > Also: I can forward my Oracle script for creating tables and could
> > include also instructions on how to get imp 3.1 working on Suse 7.2 if
> > there is any interest. If so please let me know who to send to.
> Oracle table creation scripts would be great! You can send them to this
> list, or preferably dev@lists.horde.org.
> -chuck
> --
> Charles Hagenbuch, <chuck@horde.org>
> "What was and what may be, lie, like children whose faces we cannot see, in
> the arms of silence. All we ever have is here, now." - Ursula K. Le Guin
> --
> IMP mailing list
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: imp-unsubscribe@lists.horde.org

---------------------- multipart/mixed attachment
A non-text attachment was scrubbed...
Type: application/octet-stream
Size: 6677 bytes
Desc: not available
Url : http://lists.horde.org/archives/imp/attachments/7492c2cd/ORACLE_CREATE.SQL

---------------------- multipart/mixed attachment--