Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Session id
hi,
you can use USERENV('SESSIONID'), if this may help...
bye
"Dong" <dong.wang_at_core.ca> a écrit dans le message de news:
772ee5fa.0110041246.70c977cc_at_posting.google.com...
> Hi there,
>
> Can somebody help me on this?
>
> I'm going to submit some jobs(with the same PL/SQL stored procedure)
> to the job queue, and inside the stored procedure, I need a way to get
> current session id (not DBMS_SESSION.UNIQUE_SESSION_ID) or its own job
> number. Either way would be helpful. I don't have any input from the
> parameter list.
>
> Thanks in advance,
> Dong
Received on Thu Oct 04 2001 - 18:43:45 CDT