Re: triggers and stored procedures
> solved by adding limit 1 within selects
That hides the problem, also introduces arbitrariness into the result since you're not specifying which of multiple values is to be returned.
Given these ambguities, if it's my problem my choice is to go back to the beginning and try for a model that avoids these difficulties. There are other problems in the posted table designs that also indicate the need for a fresh start. And while you're at it, it's always a bad idea to use misspelt English words as table or column names ("archieve").
Edited 2 time(s). Last edit at 08/24/2015 09:30AM by Peter Brawley.
Subject
Written By
Posted
Re: triggers and stored procedures
August 23, 2015 09:44PM
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.