- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Avoid the execution of an insert from an trigg...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-03-2002 03:32 AM
тАО12-03-2002 03:32 AM
Avoid the execution of an insert from an trigger
If the values are wrong I don't want the insert to be executed.
How can I do?
Thanks in advance.
Raquel
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-03-2002 04:22 AM
тАО12-03-2002 04:22 AM
Re: Avoid the execution of an insert from an trigger
How about a rollback command?
Regards,
Justo.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-03-2002 04:49 AM
тАО12-03-2002 04:49 AM
Re: Avoid the execution of an insert from an trigger
Do you searching something like this:
CREATE OR REPLACE TRIGGER
AFTER INSERT ON
FOR EACH ROW
BEGIN
IF
END IF;
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE (???error???);
END;
/
Chris
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-03-2002 04:54 AM
тАО12-03-2002 04:54 AM
Re: Avoid the execution of an insert from an trigger
Please replace AFTER INSERT with BEFORE INSERT
Chris
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-03-2002 05:03 AM
тАО12-03-2002 05:03 AM
Re: Avoid the execution of an insert from an trigger
CREATE OR REPLACE TRIGGER
BEFORE INSERT on
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-03-2002 10:00 AM
тАО12-03-2002 10:00 AM
Re: Avoid the execution of an insert from an trigger
Otherwise, please post a better idea of what you are looking to do, and we might be able to give you a better idea of a way to do it.
Brian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-09-2002 08:10 AM
тАО12-09-2002 08:10 AM
Re: Avoid the execution of an insert from an trigger
Have you tried using WHEN ?
CREATE OR REPLACE TRIGGER
BEFORE INSERT on