Skip to content

Instantly share code, notes, and snippets.

@velll
Created June 3, 2014 12:00
Show Gist options
  • Select an option

  • Save velll/029ca6af0f2acd9a53fc to your computer and use it in GitHub Desktop.

Select an option

Save velll/029ca6af0f2acd9a53fc to your computer and use it in GitHub Desktop.
Handled no data found doesnt change variable
DECLARE
rc_SG SI_SUBJ_GOODS%ROWTYPE;
BEGIN
rc_SG.N_SUBJ_GOOD_ID := -1;
BEGIN
SELECT *
INTO rc_SG
FROM SI_SUBJ_GOODS
WHERE 1 = 2;
EXCEPTION WHEN no_data_found THEN NULL;
END;
MAIN.RAISE_ERROR_OLD(rc_SG.N_SUBJ_GOOD_ID);
END;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment