Re: How do you return a generated SEQUENCE?

Neal,

You don't say how the client is performing the update. I assume that there is some reason the client can't follow the update with a query and get the number directly.

If you can program PL/SQL, one approach you could try is to use the DBMS_PIPE package, which allows you to call operating-system shell commands, and email the generated number to the client. I know that Unix mail will allow this, but I'm not sure about others like NT or VMS.

Let me know how it goes,

Ken

Neal Hill wrote:
>
> Hello, we have a problem that perhaps someone else has come across and
> solved:
>
> We have an insert trigger that is setting a field with a generated
> sequence number. We need to know what that generated sequence number
> was after the trigger finished updating the field, so that the client
> may keep that as a key.
>
  Received on Wed Nov 05 1997 - 00:00:00 CST