The syntax of calling subprograms with no parameters.
SQL>
SQL> CREATE OR REPLACE PROCEDURE NoParamsP AS
2 BEGIN
3 DBMS_OUTPUT.PUT_LINE('No Parameters!');
4 END NoParamsP;
5 /
Procedure created.
SQL>
SQL> show errors
No errors.
SQL>
SQL> CREATE OR REPLACE FUNCTION NoParamsF
2 RETURN DATE AS
3 BEGIN
4 RETURN SYSDATE;
5 END NoParamsF;
6 /
Function created.
SQL>
SQL>
SQL> show errors
No errors.
SQL>
SQL> BEGIN
2 NoParamsP;
3 DBMS_OUTPUT.PUT_LINE('Calling NoParamsF on ' || TO_CHAR(NoParamsF, 'DD-MON-YYYY'));
4 END;
5 /
No Parameters!
Calling NoParamsF on 27-OCT-2009
PL/SQL procedure successfully completed.
SQL>
SQL>
SQL>
Related examples in the same category