SELECT INTO and CURSORS

[chrisrlong]

BEGIN
....

--BEGIN
----SELECT
------COL1
----INTO
------L_Col1
----WHERE
------<whatever>
--EXCEPTION
----WHEN NO_DATA_FOUND THEN
------<whatever>
--END

...

END

HTH,

- Chris