Why can't I use a case when statement when using select in the cursor cursor?

glister

As the title, for example
select a. *, c.ovt_date,
     b.shf_at1,
     case when b.shf_of1 <b.shf_at1 then trunc (a.rcd_dat) + 1 + (b.shf_of1-trunc (b.shf_of1))
          else b.shf_of1 end
     from att_rcd a, att_supply_ovt_t c, att_shf b
      where rcd_dat = to_date ('20161127', 'yyyymmdd') and. . . . Omitted

The above SQL can have running results, but errors occur when defining the cursor, such as:

cursor test is
   select ....... statement as above

Why did it go wrong?

myaeolus

Oh. You need to execute this dynamically. Such as:

sql = 'select ....'

execute immediate 'sql';

lele303

execute immediate 'select ..'
  Learn

aaa1414

Excuse me, why do we need dynamic execution? Thank you!