Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2002
    Posts
    6

    Unanswered: INSERT INTO And LONG (Oracle: 8.1.7)

    Hi,

    Here is my sql:


    INSERT INTO GROUPE@YYY(ID_GROUPE,ANNOTATION,DESCRIPTION,ABREVI ATION)
    SELECT ID_GROUPE,ANNOTATION,DESCRIPTION,ABREVIATION FROM GROUPE

    The ANNOTATION is LONG data type. When I try to execute this I receive the error :

    ORA-00997: ILLEGAL USE OF LONG DATATYPE


    Any help?

    thanks in advance

  2. #2
    Join Date
    Apr 2003
    Location
    Minneapolis, MN
    Posts
    273
    Because, DB LINK does not support LONG datatype. You can use COPY instead.

    HTH
    Bhavin

    MS Computer Science
    OCP DBA 9i/8i

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •