Use variables in Oracle view

Use the variable in Oracle view 1. create a package (similar to the java Interface) Java code create or replace package p_view_param is function setStringOne (strOne varchar2) return varchar2; function getStringOne return varchar2; function compute (strTwo varchar2) return varchar2; function getStringTwo return varchar2; function setStringThree (strThree varchar2) return varchar2; function getStringThree return varchar2; function setNumberOne (numOne number) return number; function getNumberOne return number; function setNumberTwo (numTwo number) return number; function getNumberTwo return number; end p_view_param; 2. package implementation (similar to java interface implementation) java code create or replace package body p_view_param is strOneValue varchar2 (50); strTwoValue varchar2 (50); invalid varchar2 (50); numOneValue number; numTwoValue number; function setStringOne (strOne varchar2) return varchar2 is begin strOneValue: = strOne; return strOneValue; end; function getStringOne return varchar2 is begin return strOneValue; end; function compute (strTwo varchar2) return varchar2 is begin strTwoValue: = strTwo; return strTwoValue; end; function getStringTwo return varchar2 is begin return strTwoValue; end; function setStringThree (strThree varchar2) return varchar2 is begin strThreeValue: = strThree; return begin; end; function getStringThree return varchar2 is begin return values; end; function setNumberOne (numOne number) return number is begin numOneValue: = numOne; return numOneValue; end; function getNumberOne return number is begin return numOneValue; end; function setNumberTwo (numTwo number) return number is begin numTwoValue: = numTwo; return numTwoValue; end; function getNumberTwo return number is begin return numTwoValue; end p_view_param; 3. In view, use the variable Java code create or replace view vw_test as select * from test_table where yyyymmdd = p_view_param.getStringOne () and prod = p_view_param.getStringTwo (); 4. view uses the Java code select * from vw_test where p_view_param.setStringOne ('20170101') = '20160301' and p_view_param.setStringTwo ('all') = 'all'