Re: SQL*Loader question

Hello,

Thanks you very much, it's very a good idea. But, how can I easily retrieve this audit session identifier in the shell script that launch sqlldr.

Because I have to pass this session_id as a input parameter to the PL/SQL package.

Any idea ?

Thanks in advance

Emmanuel

In article <90h5ae$1778u$7_at_ID-62141.news.dfncis.de>,   "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
> Just use userenv('sessionid'), as that already automatically and
 monotously
> increments. No need to develop your own mechanism, providing you'r not
> connected as SYS
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> <manu_b_at_my-deja.com> wrote in message

 news:90gidu$6mf$1_at_nnrp1.deja.com...
> > Hi everybody,
> >
> > I would like to be able to load multiples text files into the same
> > table and simultaneously.
> > After, a pl/sql package is manipulating the data from the temporary
> > table to the live tables.
> > The problem is to associate a uniq session identifier to each
 sqlload
> > session (not to each rows to be loaded) and populate the temporary
> > table with this session id (as a constant).
> > All rows in a session will have the same session id.
> > The session_id should be from an Oracle sequence.
> >
> > Any powerful and reliable idea will be appreciated.
> >
> > Thanks in advance.
> >
> > Emmanuel
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Dec 05 2000 - 08:17:43 CST