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;
/

Report message to a moderator

Previous Topic: Using record_datatype as an input/output variable in procedures
Next Topic: Inverting a table using SQL
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 24 09:16:56 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.