Home » SQL & PL/SQL » SQL & PL/SQL » How to Make Schema Name as a Variable in Trigger (Oracle 9i)
icon8.gif  How to Make Schema Name as a Variable in Trigger [message #336519] Mon, 28 July 2008 00:12 Go to next message
Manoj_S
Messages: 3
Registered: July 2008
Junior Member
Hi,
I am having a base schema under which a table gets populated with the data arriving from a different application. After processing this data, trigger is supposed to write in different tables in different schemas. But the problem is that the schema names should be dynamic. Is there any way to do this? Somebody please HELP!!!
Re: How to Make Schema Name as a Variable in Trigger [message #336520 is a reply to message #336519] Mon, 28 July 2008 00:17 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow Posting Guideline as stated in URL above

HUH?
Re: How to Make Schema Name as a Variable in Trigger [message #336529 is a reply to message #336519] Mon, 28 July 2008 00:56 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Have a look at Streams.

Regards
Michel
Re: How to Make Schema Name as a Variable in Trigger [message #336530 is a reply to message #336529] Mon, 28 July 2008 01:02 Go to previous messageGo to next message
Manoj_S
Messages: 3
Registered: July 2008
Junior Member
Can you make it some more clear please...
Re: How to Make Schema Name as a Variable in Trigger [message #336534 is a reply to message #336530] Mon, 28 July 2008 01:09 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://www.oracle.com/pls/db102/portal.portal_db?selected=3#index-STR

Regards
Michel
Re: How to Make Schema Name as a Variable in Trigger [message #336536 is a reply to message #336534] Mon, 28 July 2008 01:27 Go to previous message
Manoj_S
Messages: 3
Registered: July 2008
Junior Member
I tried the same, but i dont think this much of effort is needed. So i am trying with the Execute Immediate Statements. Hope it will work... So there is no ways to give the shcema name as a variant in the triggers, which should have been easier.
Previous Topic: query problem
Next Topic: error in explicit cursor
Goto Forum:
  


Current Time: Fri Dec 09 06:08:22 CST 2016

Total time taken to generate the page: 0.09661 seconds