|
Lots wrong here... you are
attempting to use a bind
variable (:myoper) that is not
bound to a value.
Also, your select statement
| QUOTE |
SELECT operation , Lot ,
Product , Qty1
FROM d2f_prod_0_report.f_lot
WHERE operation = :myoper
AND Route = 'SL00.2RZS'
AND Product LIKE '%IX190%'; |
needs to "select into", because
you cannot simply select like
that in PL/SQL. If you think
about it, it makes sense; if you
don't select into, or open a
cursor so that the values can be
of use, then you are just
selecting to waste time, and
that will not compile.
|
