I'm currently facing a problem while I'm adding a trigger to the database that I use at home.
I'm using : Oracle Database 12c Enterprise Edition Release 22.214.171.124.0 – 64bit Production
The problem that occurs is that, when I add my trigger it compiles, but impossible to access to the content of a VARCHAR2 variable, even if it contains something.
typeEngine engine.type%TYPE = '74E';--engine.type is a VARCHAR2(4) SELECT engine.capacity INTO capacityMax FROM engine WHERE engine.type = typeEngine;
That returns me a NO DATA FOUND Exception, but the data is in the database.
Thanking you all in advance if someone has the solution to solve that issue.