SQL & PL/SQL

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Solaris: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production

-------------------------------------------------------------------------------

I got help recently using tick marks.
It's complaining about the YES in the constraint towards the bottom.
Previously, I was just using execute immediate, but was corrected to use the Qliteral...as seen here, to correct for issues with tick marks.
I guess I still don't understand what I'm doing wrong.

set serveroutput on;
declare
  v_count     number;
BEGIN
  select count(*) 
   into v_count
   from all_tables
   where table_name = 'NRV_ADMIN_REGIONS_WILLY'
   and owner = 'FS_NRIS_FSVEG';
   
   IF (v_count >= 1 )
    then dbms_output.put_line('TABLE EXISTS');  
    else
execute immediate   --Qliteral begins here
Q'{CREATE TABLE FS_NRIS_FSVEG.NRV_ADMIN_REGIONS_WILLY
(
  CN           VARCHAR2(32 BYTE) CONSTRAINT NRV_ADMIN_REG_STAT_CK NOT NULL,
  REGION_ID    VARCHAR2(2 BYTE)                 NOT NULL,
  REGION_NAME  VARCHAR2(50 BYTE)                NOT NULL,
  STATUS       VARCHAR2(3 BYTE)
)
TABLESPACE USERS_NRIS_FSVEG
RESULT_CACHE (MODE DEFAULT)
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          80K
            NEXT             1M
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


CREATE UNIQUE INDEX FS_NRIS_FSVEG.NRV_ADMIN_REG_PK ON FS_NRIS_FSVEG.NRV_ADMIN_REGIONS_WILLY
(CN)
LOGGING
TABLESPACE USERS_NRIS_FSVEG
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          80K
            NEXT             1M
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;


CREATE OR REPLACE TRIGGER FS_NRIS_FSVEG.NRV_ADMIN_REGION_INS
 BEFORE INSERT
 ON FS_NRIS_FSVEG.NRV_ADMIN_REGIONS_WILLY
 REFERENCING OLD AS OLD NEW AS NEW
 FOR EACH ROW
DECLARE
BEGIN
   --
   --
   
   --
   if :new.cn is null
   then
      :new.cn := SYS_GUID();
   end if;
   --
END;
/


ALTER TABLE FS_NRIS_FSVEG.NRV_ADMIN_REGIONS_WILLY ADD (
  CONSTRAINT NRV_ADMIN_REGION_STATUS
  CHECK (STATUS IN  ('YES','NO'))
  ENABLE VALIDATE,
  CONSTRAINT NRV_ADMIN_REG_PK
  PRIMARY KEY
  (CN)
  USING INDEX FS_NRIS_FSVEG.NRV_ADMIN_REG_PK
  ENABLE VALIDATE);

GRANT DELETE, INSERT, SELECT, UPDATE ON FS_NRIS_FSVEG.NRV_ADMIN_REGIONS_WILLY TO NRV_DATA_COLLECTOR}';   --Qliteral ends here
end if;
EXCEPTION WHEN OTHERS THEN dbms_output.put_line(sqlerrm);
END;
/