Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Get user name trigger

AzamshareefSep 24 2013

Dear All,

I have a problem with below trigger. Can anyone help me.

CREATE TABLE MASTER_TABLE(NAME VARCHAR2(1000),NUM NUMBER);

CREATE TABLE DUP_TABLE(NO NUMBER,OLD_NAME VARCHAR2(1000),NEW_NAME VARCHAR2(1000),UPDATE_DATE DATE,username varchar2(1000));

CREATE OR REPLACE TRIGGER HIST

after UPDATE OF NAME,num

   ON MASTER_TABLE

   FOR EACH ROW    

DECLARE

  PRAGMA AUTONOMOUS_TRANSACTION;

USR VARCHAR2(1000); 

BEGIN

SELECT USER INTO U FROM dual;

   INSERT INTO DUP_TABLE

   (NO,OLD_NAME,NEW_NAME,update_date,username )

   VALUES

   (:new.Num,:old.name,:new.name,sysdate,USR);

     COMMIT;

     END ;

   

     SHOW ERR

i want to put user_name(value) into usr(variable) from fnd_user table. How do i correct the above trigger though it is successfully running but it appears user. Is there any concept for calling triggers with parameters?

Comments

User598611

Hi,

Can anyone reply us please.

Thanks.

Krishna-Oracle

Hi,

Have a look at these documents

http://docs.oracle.com/cd/E11882_01/network.112/e10835/ldap.htm#NETRF011

Is It Possible To Use Ldap.Ora On The Client To Get Tnsname Entries From An Oid? (Doc ID 461151.1)

Using TNS_ADMIN with LDAP.ORA and Net Manager (Doc ID 189627.1)

What Is The Search Order For The LDAP.ORA File ? (Doc ID 363283.1)

Thanks,

Krishna

Hi,

We have to use tnsnames.ora file for connectivity.

Thanks,

Prameela

1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 22 2013
Added on Sep 24 2013
0 comments
165 views