dBASE SQL Servers - Oracle 9.2

Author

Oracle 9.2

Victor

2005-05-19, 3:23 am

Hi,

I'm not expirienced with Oracle issues. Instead of memo field in old dbase files I'm trying to use LONG field in Oracle. I do datalinking Editor object to LONG field. On rowset.Save() I'm getting folloing error all the
time :

Server Error: ORA 01410 invalid ROWID

As soon as I exclude LONG field from sql query and cancel datalink of Editor object this error disappears and all the rest works fine. There are
no any Oracle indexes for table in question.

Could anybody put me in correct direction to solve the problem ?

Thanks in Advance
Best Regards
Victor Antonov

David Kerber

2005-05-19, 7:23 am

In article <ENtJhrEXFHA.1760@news-server>,
Victor.Antonov@tridentsa.spb.ru says...
> Hi,
>
> I'm not expirienced with Oracle issues. Instead of memo field in old dbase files I'm trying to use LONG field in Oracle. I do datalinking Editor object to LONG field. On rowset.Save() I'm getting folloing error all the
> time :
>
> Server Error: ORA 01410 invalid ROWID
>
> As soon as I exclude LONG field from sql query and cancel datalink of Editor object this error disappears and all the rest works fine. There are
> no any Oracle indexes for table in question.
>
> Could anybody put me in correct direction to solve the problem ?

Check the definition of a LONG datatype. In most languages, that means
"long integer". If you're trying to store lots of text, try a "LONG
CHAR" or "LONG VARCHAR". Or possibly "LONG BINARY" if you're storing
more than just text.

>
> Thanks in Advance
> Best Regards
> Victor Antonov
>
>

--
Remove the ns_ from if replying by e-mail (but keep posts in the
newsgroups if possible).

Victor

2005-05-19, 9:23 am

David,

Thanks for answering ! Would You be so kind to give more details on how to do it please ? I'm using SQL Navigator 4 for definition of tables/columns. There is only LONG type and I can not find where to search for its definition and change it.

Thanks
Best regards
Victor

David Kerber Wrote:

> In article <ENtJhrEXFHA.1760@news-server>,
> Victor.Antonov@tridentsa.spb.ru says...
>
> Check the definition of a LONG datatype. In most languages, that means
> "long integer". If you're trying to store lots of text, try a "LONG
> CHAR" or "LONG VARCHAR". Or possibly "LONG BINARY" if you're storing
> more than just text.
>
>
> --
> Remove the ns_ from if replying by e-mail (but keep posts in the
> newsgroups if possible).

David Kerber

2005-05-19, 9:23 am

In article <ne93AcHXFHA.1768@news-server>,
Victor.Antonov@tridentsa.spb.ru says...
> David,
>
> Thanks for answering ! Would You be so kind to give more details on how to do it please ? I'm using SQL Navigator 4 for definition of tables/columns. There is only LONG type and I can not find where to search for its definition and change it.

I'm afraid I can't help you there. I've never used Oracle, and I've
never even heard of SQL Navigator. If there is any online help inside
the program, I would think you could find it there under "data types" or
"field types", but that's just speculation on my part. Maybe somebody
who's familiar with Oracle can help you here.

[color=darkred]

--
Remove the ns_ from if replying by e-mail (but keep posts in the
newsgroups if possible).

Victor

2005-05-19, 11:23 am

David,

Thanks anyhow ! Let's hope somebody will help :)

Best Regards
Victor

David Kerber Wrote:

> In article <ne93AcHXFHA.1768@news-server>,
> Victor.Antonov@tridentsa.spb.ru says...
>
> I'm afraid I can't help you there. I've never used Oracle, and I've
> never even heard of SQL Navigator. If there is any online help inside
> the program, I would think you could find it there under "data types" or
> "field types", but that's just speculation on my part. Maybe somebody
> who's familiar with Oracle can help you here.
>
>
>
>
> --
> Remove the ns_ from if replying by e-mail (but keep posts in the
> newsgroups if possible).

Victor

2005-05-20, 3:23 am

The problem is still the same. In spite of this error the data is saved in LONG field. When I just ignore this error in ON ERROR routine It goes on working unnoticed. But it is wrong ! Has it something to do with Oracle driver in BDE ? Could anybody hel
p please ?

I'm not expirienced with Oracle issues. Instead of memo field in old dbase files I'm trying to use LONG field in Oracle. I do datalinking Editor object to LONG field. On rowset.Save() I'm getting folloing error all the
time :

Server Error: ORA 01410 invalid ROWID

As soon as I exclude LONG field from sql query and cancel datalink of Editor object this error disappears and all the rest works fine. There are
no any Oracle indexes for table in question.

Victor

2005-05-20, 7:23 am

I have found walkaround of this problem. I cancelled datalink of LONG field to Editor object and started to make

field.["LONG"].Value = Editor1.Value

before saving of rowset. The error disappeared ! It is strange and it is not good I have not found the reason but walkaround is good as well :)

Thanks
Best Regards
Victor

Victor Wrote:

> The problem is still the same. In spite of this error the data is saved in LONG field. When I just ignore this error in ON ERROR routine It goes on working unnoticed. But it is wrong ! Has it something to do with Oracle driver in BDE ? Could anybody h
elp please ?
>
>
> I'm not expirienced with Oracle issues. Instead of memo field in old dbase files I'm trying to use LONG field in Oracle. I do datalinking Editor object to LONG field. On rowset.Save() I'm getting folloing error all the
> time :
>
> Server Error: ORA 01410 invalid ROWID
>
> As soon as I exclude LONG field from sql query and cancel datalink of Editor object this error disappears and all the rest works fine. There are
> no any Oracle indexes for table in question.
>
>

Sponsored Links