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 is flexfield qualifier?

3 Answers  

Hi Experts How to Create a purchase order without a requisition ?

6 Answers   Amdocs, KPMG, Oracle,

differentiate between intra & inter UOM class conversion with examples.

1 Answers   Scan Steel,

Oder of firing triggers in form

7 Answers   Oracle, Zensar,

How to develop XML report without rdf?

4 Answers   Oracle,

What r the validation types?

3 Answers  

what are stock locators and how to define them? name the tables where the stock locator information is stored. at least two.

3 Answers   Scan Steel,

what is user exit and wat program do we write in user exit?

4 Answers   iGate,

Can anybody tell me, What is the Implementation Process?

2 Answers   TCS,

What r the validation done in ap inbound ?

2 Answers   Questam,

What is request group

4 Answers   Accenture,

in procedure how to return a value

4 Answers