how to manipulate large data through trigger?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: how to manipulate large data through trigger?

  1. #1
    Join Date
    Dec 2001
    Posts
    120
    hi,

    I want to update / insert a column in my table through a trigger which is of long datatype. The trigger is failing now as long data manipulation can't be done through triggers. What could be the alternative approach of doing the same. I can change even the datatype (but to what?) if required, still the trigger is a must. The trigger handles the inserts and updates and as such can't be bypassed. So just mention what could be a possible solution to this problem.

    thanks in advance!

    Parijat Paul

  2. #2
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    I have never heard that triggers cannot be made on long datatype. However, if that is the case, you can use LOB datatypes.

    Raminder Singh

    Oracle Certified DBA: Oracle 8i, 9i


    Mail me at raminderahluwalia@rediffmail.com.

  3. #3
    Join Date
    Dec 2001
    Posts
    120

    long datatype manipulation within a trigger

    the long datatype if there within a table can't be used in : new or : old references within a trigger. This is what causing the problem. Even the same is true for CLOB!

Posting Permissions

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


Click Here to Expand Forum to Full Width