GeekArticles 
FAQ Oracle FAQtrigger problem
Author: asktom.oracle.com |
Published: 8th Sep 2007 |
Visited: 54 times |
Add CommentFiled in: Oracle FAQHi Tom, I have a 'test' trigger like this:
<code>
SQL> CREATE OR REPLACE PROCEDURE pr_valid
2 (
3 p_object_name in varchar2 ,
4 p_object_type in varchar2 ,
5 p_object_owner in varchar2
6 )
7 IS
8 --...
Read Article Sponsored Links
Related Articles
• The Stateless Problem of Ajax We are often dazzled with websites that were developed with Ajax. The interface is amazing and the interaction with users is simply beyond expectations. The asynchronous streaming of information from the server gives the user the ability to update the information in our browsers without refreshing t ...
• Another 3 EASY way to Stopping ASP.Net ViewState Problem The ASPNet pages uses ViewState field to store current data between server and client. But if you have many controls or data on your page viewstate info will become bigger than your normal html. So this helpers allows to stop viewstate prob ...
• Referencing values in update trigger Tom,
When a before update for each row trigger fires and a certain column was not set in the update statement, the :new value for the "certain column" appears to be set to the :old value by the time the trigger fires. Is there a way to determine ...
• how can I tell what sql caused my trigger to fire Hi,
We have a database table from which the rows are deleted and we have no idea how is it happening. Users claim that they are not deleting it through application.
I put an ondelete trigger on that table and stored the rows that were deleted in ...
• DDL within a Trigger Everything I have ever read about triggers explicity states that DDL, because of an implicit commit, cannot be used within a trigger. I have, though, seen in blogs and other various places where people have claimed to have gotten it to work through ...
• Windows XP 32-bit icons & TImageList problem QC#: 4653 Version: 7.0 Status: Open defect, requires resolution Resolution: Bug has been deferred until the next rel Description: Windows XP icons don't show up correctly in TImageList. They get black outline when displayed. The issue has to do with W ...
• Problem with Floating Point Execption in a Dll. QC#: 58409 Version: 10.0 Status: New defect, requires tester review Description: Some people from another project run into a nasty problem about floating point exceptions inside Dll's.
Their Unit-Tests failed randomly without a visible reason.
After ...
