Oracle Examples:
1. Oracle example of a call from a Stored Procedure:
Add the following to the declaration section of the stored procedure:
v_current_date varchar2(256);
Then add the call to the procedure:
v_current_date := WsParameterRead('CURRENT_DATE');
2. Oracle example of a call from sqlplus:
Place the following code in a text file called FileName.sql:
set pages 0 feed off heading off
SELECT WsParameterRead('CURRENT_DATE')
FROM DUAL;
Execute the file from sqlplus (using @FileName). The following out is typical:
29-MAY-09