Re: problem using long raw in trigger

From: Bob Fazio <rfazio_at_home.com.nospam>
Date: 2000/05/12
Message-ID: <NFVS4.186673$Tn4.1480795_at_news1.rdc2.pa.home.com>

From Oracle's Documentation, and since you are already using HTML which you shouldn't, I will highlight the key area.

Although LONG (and LONG RAW; see below) columns have many uses, their use has some restrictions:

  a.. Only one LONG column is allowed per table. 
  b.. LONG columns cannot be indexed. 
  c.. LONG columns cannot appear in integrity constraints. 
  d.. LONG columns cannot be used in WHERE, GROUP BY, ORDER BY, or 

CONNECT BY clauses or with the DISTINCT operator in SELECT statements.   e.. LONG columns cannot be referenced by SQL functions (such as SUBSTR or INSTR).
  f.. LONG columns cannot be used in the SELECT list of a subquery or queries combined by set operators (UNION, UNION ALL, INTERSECT, or MINUS).
  g.. LONG columns cannot be used in SQL expressions.   h.. LONG columns cannot be referenced when creating a table with a query (CREATE TABLE... AS SELECT...) or when inserting into a table or view with a query (INSERT INTO... SELECT...).   i.. A variable or argument of a PL/SQL program unit cannot be declared using the LONG datatype.
  j.. Variables in database triggers cannot be declared using the LONG or LONG RAW datatypes.
  k.. References to :NEW and :OLD in database triggers cannot be used with LONG or LONG RAW columns.
  l.. LONG and LONG RAW columns cannot be used in distributed SQL statements.
  m.. LONG and LONG RAW columns cannot be replicated.   --
  Robert Fazio, Oracle DBA
  rfazio_at_home.com
  remove nospam from reply address
  http://24.8.218.197/
  "Minicooper News" <Minicooper_at_quadrat.be> wrote in message news:7fUS4.93$Qt4.2434_at_nreader2.kpnqwest.net...   I need to write a trigger that copies a value out of one table into another and i'm experiencing great troubles in copying the LONG RAW field.

  for example:

  table: Y ( Y1 integer, Y2 varchar2(20), Y3 long raw)   table: X ( X1 integer, X2 varchar2(20), X3 long raw)

  trigger: Y to X before insert or update on Y referencing new as new and old as old for each row

             begin
                  insert into X (X1,X2,X3) values (:new.Y1, :new.Y2, 
:new.Y3);
             end;

  now i only get the first 2 values in the table without the long raw !!

  Can any1 help me here !!!!!??????

  mailto:jurgen_at_quadrat.be

--

Received on Fri May 12 2000 - 00:00:00 CEST