Dynamic SQL inside a trigger
I need to create a dynamic SQL to turn a denomilized database (with each rows stored verticallly - datetime, id, value) to a normilized one (with one row and more columns - datetime, col1,col2,col3). I managed to create the procedure but when the trigger call it, raise an error saying it's not possible do that.
When will it be possible to create a dynamic SQL inside a trigger or a stored procedures called from a trigger??
Thanks
Subject
Views
Written By
Posted
Dynamic SQL inside a trigger
3450
November 26, 2005 10:36AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.