When SET SCAN ON used after END throws error
Posted
by Karthik
on Stack Overflow
See other posts from Stack Overflow
or by Karthik
Published on 2010-05-03T08:55:03Z
Indexed on
2010/05/03
9:08 UTC
Read the original article
Hit count: 145
Filed under:
Oracle
Hi, Im trying to use SET SCAN ON after as follows..
SET SCAN OFF;
DECLARE
-- declared a variable
BEGIN
--update statement
END;
SET SCAN ON;
The use of SET SCAN ON; is causing the error when i try to run the script. The error captured
ORA-06550: line 16, column 1:
PLS-00103: Encountered the symbol "SET"
06550. 00000 - "line %s, column %s:\n%s"
*Cause: Usually a PL/SQL compilation error.
*Action:
© Stack Overflow or respective owner
