ORA-02291: how to assign value to varchar2 variable depending on specific input? [message #625644] |
Sun, 12 October 2014 06:00 |
|
Silently_Quiet_Logic
Messages: 1 Registered: October 2014
|
Junior Member |
|
|
Hi all,
fresh to the forums, I'm using SQL Developer and am aware that error ORA-02291 has been
discussed many times, my situation is as follows:
(All variables used are varchar2(100), tables A and B were created and empty at first)
I have a unique non-primary key attribute (i.e. Animal) in table A that is
referenced in table B as a foreign key ('Species'), a value of 'Tabby Cat' was
inserted into Table A's Animal column, when I try to insert value 'Cat' into
Table B's Species column, I get the ORA-02291 error as expected.
Now I want the database to react so that when it reads 'Cat' in 'Tabby Cat' from
Table A, it would refer to it as instead 'Cat', how would one program this so that
it works for future inserts as well? Thanks in advance,
Silently_Quiet_Logic
|
|
|
|
|