Answer / anang

Yes We can create a synony for a trigger like this

Create or replace trigger test before insert on emp
begin
dbms_output.put_line('Hi');
end;
Create the trigger in scott schema

and connect to apps schema and create a synonym like this

create public synonym test for scott.test;

or

create synonym test1 for scott.test;

Answer / arun

We can't create synonyms on trigger

Answer / amit

Yes, We can create Public and Private Synonyms on Triggers.

Answer / avinash

I have created a trriger on CREATE,in which i m giving
execute immediate command for creating a synonym and using
dbms_job.submit .
it is not giving any error but its not creating any synonym
on the table...
code:

create or replace trigger bdesai.DR_CRA
after CREATE OR DROP on bdesai.schema
declare
l_str varchar2(255);
l_str1 varchar2(255);
l_job number;
begin
CASE ORA_SYSEVENT
WHEN 'CREATE' THEN
if (ora_dict_obj_type = 'TABLE') then
l_str := 'execute immediate "grant select on bdesai.'
||ora_dict_obj_name ||' to eqhub_developer";';
l_str1 := 'execute immediate "create or replace synonym
eqhub_developer'||'.'||ora_dict_obj_name ||' for
bdesai'||'.'||ora_dict_obj_name||'";';
DBMS_OUTPUT.PUT_LINE(replace(l_str,'"',''''));
DBMS_OUTPUT.PUT_LINE(replace(l_str1,'"',''''));
dbms_job.submit( l_job, replace(l_str,'"','''') );
dbms_job.submit( l_job, replace(l_str1,'"','''') );

END IF;
WHEN 'DROP' THEN
if ( ora_dict_obj_type = 'TABLE') then
l_str := 'execute immediate "revoke select on bdesai.'
||ora_dict_obj_name ||' from eqhub_developer";';
l_str1 := 'execute immediate "drop synonym
eqhub_developer'||'.'||ora_dict_obj_name||'";';
DBMS_OUTPUT.PUT_LINE(replace(l_str,'"',''''));
DBMS_OUTPUT.PUT_LINE(replace(l_str1,'"',''''));
dbms_job.submit( l_job, replace(l_str,'"','''') );
dbms_job.submit( l_job, replace(l_str1,'"','''') );
END IF;
END CASE;

end;
/

Answer / phani

I agress, we can create synonym for triggers. infact we can
create synonym for any object in the database. But, why
anyone need to create the synonym for any trigger. It is not
required at all.

For the Better understanding about the Oracle Applications.
I suggest you go through the following link.

http://alloracletech.blogspot.com/2008/08/oracle-applications-concept.html

Regards,
Phani

Answer / natthu matte

Yes we can create a synonym of trigger because it is a
database object like others,but here what is the use of
this synonym..? answere is nothing. u can not use the
functionality of trigger by using this synonym of trigger.

Answer / prasad

We connt create Synonym for Trigger.

what are the sql attributes?

2 Answers  

how to call report from oracle oracle apps11i?

3 Answers   Genpact,

what is item status? name the related table.

1 Answers   Scan Steel,

where we will put the control file ,where we will run sql star loader what is the cmd?

1 Answers   Cap Gemini, KPMG,

In interface how u find errors and how to solve. How to fix it?

3 Answers  

Steps for DFF registration

2 Answers   IBM, Savvis, Wipro,

HOW CAN U KNOW THE STAUS OF PO?

1 Answers   TCS,

what is aim methodolozy

1 Answers   Wipro,

what are the difference between oracle discoverer and report6i

1 Answers  

Can you define an erp system?

0 Answers  

how to avoid duplicate data while uploading data from flatfile to staging table? some validations

5 Answers   Amdocs,

What should be the batch size (number of customer records) general guidelines for optimal performance?

1 Answers