The syntax of calling subprograms with no parameters. : Procedure Function Body « Stored Procedure Function « Oracle PL / SQL






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

1.Use table column type as an variable type