is iCount number; /* take type from table field */ iKategp factory.an_hr_table.kategp%type; begin ... begin select kategp into iKategp from factory.an_hr_table where osc = pOsc; exception when NO_DATA_FOUND then pErrorMessage := 'No data found for worker: ' || pOsc; return( -1 ); end; ...
Microsoft AX 2012, X++, C#, SQL server, SSRS, Java, JavaFX, Oracle, PL/SQL, Delphi - codes examples, step-by-step tutorials, experiences.
Friday, December 1, 2017
ORACLE - How handle pl/sql exception
Typical example for handling pl/sql exception (when no row is found in select):
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment