queryfilter.sql

来自「对于移动数据库而言」· SQL 代码 · 共 36 行

create or replace package PKG_QueryFilter is
   
   
	-- Author  : Dongyi Chen
	-- Created : 2009-4-22
	-- Purpose : Implementation of Dynamic Query Filtering
	
	-- Public type declarations
	TYPE Result_CURSOR IS REF CURSOR;
  	
	-- Public Procedure declarations
	
	/*-------------------------------------------------------------------------
   || Description ：Filtering the result of query into the cursor
   ||
   || Parameter ：Notation      Meaning            I/O    Type
   ||            -------------------------------------------------------------
   ||            p_Projection  Shown Attributes   Input   VARCHAR2(100)
   ||            p_TableName   Related Tables     Input   VARCHAR2(30)
   ||            p_Condition   Conditions         Input   VARCHAR2(1000)
   ||            p_Cursor      Filtering Result   Output  Result_CURSOR
   ||            p_AppCode     Execution Code     Output  NUMBER
   ||            p_ErrorMsg    Error Message      Output  VARCHAR2(100)
   ||
   || Author ：Dongyi Chen       Date ：2009-4-22
   ||-------------------------------------------------------------------------*/
   PROCEDURE Prc_QueryFilter ( p_Projection IN  Varchar2,
	                            p_TableName  IN  Varchar2,
	                            p_Condition  IN  Varchar2,
	                            p_Cursor     Out Result_CURSOR,
	                            p_AppCode    OUT NUMBER,
	                            p_ErrorMsg   OUT Varchar2);
  

end PKG_QueryFilter;
/