Hi Thomas

In other words, do it all in one procedure? :-( I don't think I can do that.

I receive an SMS message. The first part of the message is what is inserted
in the above procedure. The second part of the message contains binary data
that must be decoded before it is inserted into the DB. Furthermore, the
second part of the data contains multiple records, each of which "belong"
to the "first" part of the message.

So I only want to call the first procedure once. The second procedure gets
called 1 or many times.

Thanks

Tim

>That's fine so far. Simply call the SP above in your second
>procedure. The following should get you started.
>
>...
>DECLARE VARIABLE MSGNO INTEGER;
>BEGIN
> EXECUTE PROCEDURE INSERT_SMSMSG (...) RETURNING_VALUES :MSGNO;
> // Do whatever you want with MSGNO now
>END
>
>Is this what you are looking for?
>
>HTH,
>Thomas Steinmaurer

[Non-text portions of this message have been removed]