Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Returning an output parameter

Returning an output parameter

From: David Bradley <davidbradley_at_home.com>
Date: 2000/05/24
Message-ID: <C9VW4.18734$m7.3025665@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 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US