Click here to Skip to main content
15,888,113 members
Please Sign up or sign in to vote.
4.00/5 (1 vote)
See more:
hi iam use this code
SQL
PROCEDURE "NEWS_SEARCH" (dateto IN varchar2 ,datef IN varchar2 , subject IN varchar2)
IS
 declare TYPE  r  IS table(s IN varchar2)



BEGIN
--select * from r;

END;


this error
XML
Error   23  PLS-00103: Encountered the symbol "DECLARE" when expecting one of the following:

   begin function pragma procedure subtype type <an identifier>
   <a double-quoted delimited-identifier> current cursor delete
   exists prior external language
    oracle:{2.0}{Oracle.Management.Omo.DbProviders.OracleDataAccessDbProvider}LOCALHOST:1521/ORADB...PWS/Procedure/PWS/NEWS_SEARCH  3   2
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900