Re: Direct Path APIs & sequences

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 22 Apr 2003 00:43:47 -0700
Message-ID: <a20d28ee.0304212343.32027ec1_at_posting.google.com>


momossa_at_yahoo.com (Mohamed) wrote in message news:<20a5af10.0304202341.7f928e71_at_posting.google.com>...
> Hi guys,
> I'm using Oracle Direct Path APis to load data from huge files into DB
> table. I need to use some feature that are provided in SQL Loader
> like:
> generating sequence for DB column for each inserted record. How can I
> acheive that using DP?
>
> Also I want to split some fileds from the file into multiple columns
> depending on some criteria, ex. File (Name) --> (DB) [First Name] &
> [Last Name]
>
> Thanx in advance

1 You can't. Triggers don't fire
2 just use an appropiate function definition as outlined in the documentation column ":<function call>"

Regards

Sybrand Bakker
Senior Oracle DBA Received on Tue Apr 22 2003 - 09:43:47 CEST

Original text of this message