PLS-00201: identifier 'DBMS_SQL' must be declared
785153Sep 3 2010 — edited Nov 19 2011Windows XP with 10.2.0.1.0
I have a store procedure package contains codes as below. As soon as I execute the store procedure package it prompts me error as
PLS-00201: identifier 'DBMS_SQL' must be declared. Please help. Thanks.
cid := DBMS_SQL.OPEN_CURSOR;
DBMS_SQL.PARSE(cid,'DROP VIEW ' ||v.tname,
DBMS_SQL.Native);
vvalue := DBMS_SQL.EXECUTE(cid);