Solved

Trigger to insert to table which is in database link

Posted on 2008-06-23
4
1,492 Views
Last Modified: 2013-12-18
I create a database link for my database named T24 , whenever  DOC table in our ddatabase is inserted , my trigger shall insert into VPB_STMT_ENTRY  table in Databaselink . I write the trigger but complication is error .

Help me please!
CREATE OR REPLACE TRIGGER sms_t24
    AFTER INSERT
        ON doc
        FOR EACH ROW
    
DECLARE
        v_username varchar2(10);
 
BEGIN
       
insert into vpb_stmt_entry@t24 
(id,
 account,
 update_time
)
 
 values
(:new.auth_code,
 :new.target_number,
 :new.AMND_DATE
 );
 END;

Open in new window

0
Comment
Question by:dinhchung82
  • 2
  • 2
4 Comments
 
LVL 16

Expert Comment

by:Milleniumaire
ID: 21845206
The code looks okay, so I'm guessing the problem is related to permission.  

What is the compilation error?
0
 
LVL 5

Author Comment

by:dinhchung82
ID: 21845997
I use pl/sql tool to write and compile . The error is "Warning: Trigger created with compilation errors"
I am newbie in pl/sql , would you tell me the way to show the error ?
0
 
LVL 16

Accepted Solution

by:
Milleniumaire earned 50 total points
ID: 21846028
Do you mean you use sqlplus?

Try typing the following after attempting to create the trigger:

show errors;
0
 
LVL 5

Author Closing Comment

by:dinhchung82
ID: 31469692
Thanks so much , I am so tired for working all day so have mistake with typing .
The error is below when i use your command.
 "LINE/COL ERROR
-------- ------------------------------------------------
8/3      PL/SQL: ORA-00904: "ACCOUNT": invalid identifier
6/1      PL/SQL: SQL Statement ignored
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Oracle SQL Select unique values from two columns 4 79
exp/imp 25 98
Creation date for a PDB 5 60
PL/SQL: ORA-00979: not a GROUP BY expression 3 52
This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question