如何在生产者orcale中返回表 [英] how return table in producer orcale

问题描述

hi
iam使用此代码

hi iam use this code

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错误

this error

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

推荐答案

这篇关于如何在生产者orcale中返回表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！