Re: CSV's - what's the Oracle Idiom?

[Quoted] You can't actually shell out, but you can call an external procedure, which [Quoted] could be setup to call sqlldr.

But does the stored procedure have to be the one to start sqlldr? Why not have a job on the system call the stored proc, and when it is done then call sqlldr?

--
Robert Fazio, Oracle DBA
rfazio_at_home.com
remove nospam from reply address
http://24.8.218.197/
"Ken Van Allen" <kennyv_at_digisys.net> wrote in message
news:8g1qqv$rh6$1_at_ruby.digisys.net...


> Hi all,


>

> I'm very new to Oracle (although not to programming in general).

>

> Need to load a CSV file into a table, and I've run smack up against the

> utl_file.get_line 1022 character limit.

>

> I'm looking at SQL Loader - but how does one shell out to call SQL Loader

> from a PL/SQL procedure?

>

> TIA,

>

> Ken

>

>