Re: Using Value of OUT Parameter

dtburke_at_software.rockwell.com (David Burke) wrote in message news:<87685036.0112171104.1a21207e_at_posting.google.com>...
> I am Executing a Stored Proc. (with an OUT value) within a Stored
> Proc.
> I need to Get the Value of the OUT parameter, from the First Proc.,
> for an INSERT statement in the Other Proc.
> Code Snippet:
>
> BEGIN
> DECLARE lSeqId;
> BEGIN
> lSeqId := 1;
>
> /*This procedure takes an input and returns a new SequenceId*/
> spGetSeqNumber('TableName',lSeqId);

What are u doing in this procedure... Check that Logic.

> INSERT INTO MyTable(lId, sName) VALUES (lSeqId, 'Smith');
>
> END;
>
> END;
>
> Why is lSeqId == NULL when the INSERT is executed?

Regards,
Ganesh R Received on Mon Dec 17 2001 - 23:37:26 CST