Re: extract data from a LONG RAW field

Does the following help:

   Oracle Product Document Library (C) Oracle Corporation   Manual: ORACLE 7.3 SERVER CODES Reference: A14538-16

 ORA-00932 inconsistent datatypes

  Cause: Either

           o An attempt was made to perform an
             operation on incompatible datatypes. For
             example, adding a character field to a date
             field (dates may only be added to numeric
             fields) or concatenating a character field
             with a long field.

           o An attempt was made to perform an
             operation on a database object (such as a
             table or view) that is not intended for normal
             use. For example, system tables cannot be
             modified by a user. Note that on rare
             occasions this error occurs because a
             misspelled object name matched a restricted
             object's name.

           o An attempt was made to use an
             undocumented view.

  Action: If the cause is

           o different datatypes, then use consistent
             datatypes. For example, convert the character
             field to a numeric field with the TO_NUMBER
             function before adding it to the date field.
             Functions may not be used with long fields.

           o an object not intended for normal use,
             then do not access the restricted object.

Christophe wrote in message <6t8op4$q8t$1_at_platane.wanadoo.fr>...
>From Christophe LUCET,
>L.S.A. :
>Hello!
>I have a problem : i need to extract data from a LONG RAW field but the
>command line :
>SELECT CLI_OBS FROM TABLE; (where CLI_OBS IS MY LONG RAW field)
>When executing, i have the error code ORA-00932 and i had not found any
help
>in the Oracle Documentation.
>If someone can help me, i would be very appreciative.
>My e-mail : clucet_at_perinfo.com .
>Hi!
>
>
>
Received on Mon Sep 14 1998 - 09:51:46 CDT