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 count(*) from po_vendors(any table)? what does it do and what is count(1) from po_vendors(any table)? what is count(0) from po_vendors(any table) the out put is same what is the difference

4 Answers   IBM,

What is GLOBAL TEMPORARY TABLE and It's significance ?

3 Answers   KPIT,

List some exceptions other than NO_DATA_FOUND, TOO_MANY_ROWS and WHEN OTHERS

3 Answers   Satyam,

Tell me some thing about SQL-LOADER.

2 Answers   IBM,

Exception Handilings?

1 Answers  

HOW CAN U KNOW THE STAUS OF PO?

1 Answers   TCS,

A file has both header and corresponding lines. Explain design to load this data into respective interface tables.

1 Answers   Satyam,

How to report output like below supplier name date amount abc software jan/11 10000 /* jan month total transactions*/ abc software feb/12 30000 /* feb month total transactions*/ dell computers jan/13 45000 /* jan month total transactions*/

4 Answers   Satyam,

In unix Schell sript what is very 1st line to be wriiten .

2 Answers   IBM,

which parameters passed in report in oracle developer how to pass

1 Answers   Wipro,

How to write the no data found in XML Publiser Report in apps?

2 Answers   UST,

How many schemas we have? how many you have used?

0 Answers