Using Value of OUT Parameter

From: David Burke <dtburke_at_software.rockwell.com>
Date: 17 Dec 2001 11:04:42 -0800
Message-ID: <87685036.0112171104.1a21207e@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);
INSERT INTO MyTable(lId, sName) VALUES (lSeqId, 'Smith');

END; END; Why is lSeqId == NULL when the INSERT is executed? Received on Mon Dec 17 2001 - 13:04:42 CST