Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Trigger to insert to table which is in database link

Posted on 2008-06-23
4
Medium Priority
?
1,624 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Enroll in October's Free Course of the Month

Do you work with and analyze data? Enroll in October's Course of the Month for 7+ hours of SQL training, allowing you to quickly and efficiently store or retrieve data. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

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

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

636 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