?
Solved

Trigger to insert to table which is in database link

Posted on 2008-06-23
4
Medium Priority
?
1,735 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 200 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

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

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

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that useā€¦
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
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

601 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