Re: Search inside a long raw field

You can't search a LONG. Don't add additional varchar2 fields, either, as that is not correct relational design. What you can do is add another table called something like REMARKS. There would be four fields (in pseudo code):

CREATE TABLE remarks
(
remark_number NUMBER, --(PK) use a sequence parent_id NUMBER, -- (FK) use the appropriate column name and data type from the "parent" table
remark_entry_date, DATE DEFAULT SYSDATE-- date and time stamp remark VARCHAR2(4000)
)
;

Create the appropriate constraints, etc. Remove remarks from your original table. All remarks go in this table. Your app would have to be coded to place the FK and remark in the table.

HTH "Hans Börjesson" <hansb_at_REMvendimo.REM.com> wrote in message news:bk9b4n$6v6$1_at_yggdrasil.utfors.se...
> Hi!
>
> We have an application, which uses RDO to access Oracle database
(Microsoft
> ODBC for Oracle). The user is able to save free text like a note which we
> today store in a varchar2 field. This is limited to 4000 characters. We
> would like to increase this but we are limited on the datatypes we can use
> because we are using Microsoft ODBC driver (unfortunatley we cannot
migrate
> to Oracle's driver for other reasons and to migrate to ADO or something
> similar is not possible at the time being). I guess the only option we
have
> is the long raw datatype?
>
> Will it be possible to do a search in a long raw field (from a sp maybe)?
I
> guess (if it is possible) the performance will be (s)low? Any other
options
> (adding several varchar2 fields may be a workable solution but not a good
> one)?
>
> BTW We should support Oracle 8.1.7 and higher.
>
> Regards
> /Hans
>
>
Received on Wed Sep 17 2003 - 13:39:19 CDT