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;
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
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)