Clob type parameter : Function Parameters « Stored Procedure Function « Oracle PL / SQL





Clob type parameter

   

SQL> CREATE TABLE myTable (
  2    id          INTEGER PRIMARY KEY,
  3    clob_column CLOB NOT NULL
  4  );

Table created.

SQL>
SQL> -- create the PL/SQL procedures and methods
SQL> CREATE OR REPLACE PROCEDURE myProcedure(clob_par IN OUT CLOB,id_par IN INTEGER) IS
  2  BEGIN
  3    SELECT clob_column INTO clob_par FROM myTable WHERE id = id_par;
  4  END myProcedure;
  5  /

Procedure created.

SQL>
SQL>
SQL> drop table myTable;

Table dropped.

SQL>

   
    
    
  










Related examples in the same category

1.Pass value to function parameter
2.Boolean value function parameter
3.The FullName Function
4.A stored function with no parameters.
5.Use Column type as the function parameter type
6.Varray type parameter
7.Positional Notation
8.Get circle area
9.Named Notation
10.Pass number value to function
11.Mixed Name and Position Notation Calls