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; ...
No comments:
Post a Comment