Home » RDBMS Server » Server Administration » Re: Using record_datatype as an input/output variable in procedures
Re: Using record_datatype as an input/output variable in procedures [message #369643] Fri, 28 January 2000 12:36
Thierry Van der Auwera
Messages: 44
Registered: January 2000
Member
Yes you can,

Example:

CREATE OR REPLACE PACKAGE BODY emp_doit IS

FUNCTION testemp (p_rEMP IN OUT EMP%ROWTYPE
) RETURN BOOLEAN IS

BEGIN
.....
RETURN TRUE;
EXCEPTION
WHEN OTHERS THEN
RETURN FALSE ;
END testemp;
END;
/
Previous Topic: Using record_datatype as an input/output variable in procedures
Next Topic: Inverting a table using SQL
Goto Forum:
  


Current Time: Wed Oct 21 11:55:42 CDT 2020