create or replace
PROCEDURE BI_DataTable(SQLWHERE IN VARCHAR2, DataTable OUT SYS_REFCURSOR) AS
p_sql VARCHAR2(1000) not null := 'SELECT * FROM demobisa001_1 where 1=1 ' || sqlwhere;
BEGIN
execute immediate p_sql ;
OPEN DataTable FOR p_sql;
END BI_DataTable;
沒有留言:
張貼留言