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.

List the types of flexfield?

0 Answers  

What is REF Cursor?

19 Answers   Infosys, Intelligroup,

Need Training & Internship with guaranteed Job in ERP - Oracle Apps Tech?

4 Answers   Zensar,

HOW MANY LANGUAGES FOLDERS ARE ONE ORACLE APPLICATION

1 Answers   TCS,

Can We Create a Synonym On Trigger?

7 Answers   Exeter, Oracle,

If there is any issue then whom do you report.(this is imp question for every interview)

3 Answers   Accenture,

API?s FOR CUSTOMER INTERFACE? Tell me some API's?

1 Answers  

in one report using two layout models.if yes how to do

2 Answers  

explain registration steps of a concurrent program.

1 Answers   TCS,

what u did after ur btech(2009) till now? why did u prefer oracle apps technical?

1 Answers   Intelligroup,

List of all the modules under Manufacturing, Finance and Distribution in oracle applications?

0 Answers  

How to make Parameter as Mandatory?

2 Answers