RE: Returning an output parameter

1.-

SET SERVEROUTPUT ON
DECLARE theid NUMBER;
BEGIN
    SP_PERSONNEL_INSERT('TEST','435787226',theid);     dbms_output.put_line( to_char(theid) ); END;
/

OR

2.-

VAR theid NUMBER
EXECUTE SP_PERSONNEL_INSERT( 'TEST', '435787226', :theid ) PRINT theid

David Bradley <davidbradley_at_home.com> escribió en el mensaje de noticias C9VW4.18734$m7.3025665_at_news1.rdc2.tx.home.com...
> 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