Have Geek Brain

When SET SCAN ON is used after END throws an error

I am trying to use SET SCAN ON after the following.

SET SCAN OFF;

DECLARE
  -- declared a variable
BEGIN
  --update statement
END;

SET SCAN ON;

Using SET SCAN ON; throws an error when I try to run the script. Fixed bug

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:
+2


a source to share


1 answer


If that's exactly what you're trying to run, it's simple. Add /

to complete the anonymous PL / SQL block:

SET SCAN OFF; 

DECLARE 
  -- declared a variable 
BEGIN 
  --update statement 
END; 
/

SET SCAN ON;


This is because PL / SQL syntax is used ;

to mark the end of a line of code, so we need to /

run our program.

+5


a source






More articles:


All Articles