oracle - PLSQL select query in BEGIN block -

oracle - PLSQL select query in BEGIN block -

create or replace procedure validate_date strabc date; strdummy varchar2(20); cursor c_example select * dummytable; begin r_example in c_retnxweek loop strabc := r_retnxweek.something; strdummy := r_retnxweek.something; end loop; if (something < something) else strdummy:= select * sometable = something; <-----alternative this? end if; end validate_date;

i have basic store procedure template above, have cursor select record table, in if else statement in begin block, wish checking on info selecting table, since cannot set cursor in begin block, how can that?

the select statement result cannot stored stated, should done via

it should utilize into clause please refer https://docs.oracle.com/cd/b19306_01/appdev.102/b14261/returninginto_clause.htm

oracle plsql