pankaj_wolfhunter_at_yahoo.co.in wrote:
> I have a file(lobfile.001) which consist of lobdata and another
> file(loblocator.txt) which consist
> of byte position for each lob in lobfile.001
>
> Contents of lobfile.001 is:
> start1 UNIT TESTING A STORED PROCEDURE Unit Testing a Stored Procedure
> invovles these five steps:
>
> 1) Define the expected outcomes.
> ---------------------------------------------------
> ---------------------------------------------------
>
> Content of loblocator.txt is:
> "lobfile.001.0.1047148/"
> "lobfile.001.1047148.1047148/"
> -----------------------------------------------
>
> In loblocator, lobfile.001 specifies the lobfile name and "0.1047148"
> specifies the byte position
> for the lobs in that file i.e the record starts at 0 position byte till
> the 104718 byte.
>
> I want to import these lobs using their byte position into Oracle table
> columns using sqlloader
> Does anyone know the exact way of doing this through sqlloader.
>
> Note: The lobfile.001 contains several lobrecords without any
> delimiters. The only way to
> differentiate these records from each other is the byte position
> specified by the loblocator.txt
>
> Any help will be appreciated.
> TIA
Use DBMS_LOB built-in package. See the READ procedure in Morgan's
Library at www.psoug.org.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Fri Oct 14 2005 - 02:09:28 CDT
