[rt-users] Oracle Errors

Joop van de Wege JoopvandeWege at mococo.nl
Wed Jan 25 07:31:56 EST 2006


On Wed, 25 Jan 2006 07:11:03 -0500
Jesse Vincent <jesse at bestpractical.com> wrote:

> 
> 
> 
> > There is atleast one problem that I have spotted and that is that
> > schema.Oracle contains two empty lines in CREATE TABLE
> > ObjectCustomFieldValues which don't belong there.
> > That is the second set of errors you get. The first is an indication
> > that an sequence with that name already exists in the schema of that
> > Oracle users you're RT installing in.
> > 
> 
> Oracle can't handle newlines in schema definitions? Or is it something
> else choking? Regardless, I've removed them. Thanks.
No not Oracle itself but SQLPlus is the culprit. Just tried it and
ofcourse used my favourite tool, which isn't SQLPlus, and it worked with
newlines in the create table statement. SQLPlus certainly doesn't.

Joop

-- 
Joop van de Wege <JoopvandeWege at mococo.nl>




More information about the rt-users mailing list