Returning an output parameter
From: David Bradley <davidbradley_at_home.com>
Date: 2000/05/24
Message-ID: <C9VW4.18734$m7.3025665_at_news1.rdc2.tx.home.com>#1/1
Date: 2000/05/24
Message-ID: <C9VW4.18734$m7.3025665_at_news1.rdc2.tx.home.com>#1/1
I am using and SQL Worksheet and trying to return an output parameter. The following code runs but does not seem to print the output variable. Can anyone help with this one?
Thank you,
David
SET SERVEROUTPUT ON
DECLARE theid NUMBER;
BEGIN
SP_PERSONNEL_INSERT('TEST','435787226',theid);
END;
/
PRINT theid;
Received on Wed May 24 2000 - 00:00:00 CEST