What I'm trying to do is this:

Write a script that will pull a list of filenames with a specific
extention, from a specific directory, into an Oracle table.

I've looked at the commands to shell out into DOS but I don't see how
to do it.

This is a script I will be running multiple time with the list of
filenames possibly changing, not a one-time thing.

Any ideas?

blindsey, 23.09.2008 18:20:

But something along the lines (in a batch file)

------- snip --------
@echo off
echo -- Insert filenames into table > do_insert.sql
for %%i in (*.zip) do echo insert into the_table (filename) values ('%%i'); >> do_insert.sql
sqlplus user/password@db @do_insert.sql
------- snip --------

should do the trick

Thomas

blindsey, 23.09.2008 18:20:

But something along the lines (in a batch file)

------- snip --------
@echo off
echo -- Insert filenames into table > do_insert.sql
for %%i in (*.zip) do echo insert into the_table (filename) values ('%%i'); >> do_insert.sql
sqlplus user/password@db @do_insert.sql
------- snip --------

should do the trick

Thomas

blindsey, 23.09.2008 18:20:

But something along the lines (in a batch file)

------- snip --------
@echo off
echo -- Insert filenames into table > do_insert.sql
for %%i in (*.zip) do echo insert into the_table (filename) values ('%%i'); >> do_insert.sql
sqlplus user/password@db @do_insert.sql
------- snip --------

should do the trick

Thomas

blindsey, 23.09.2008 18:20:

But something along the lines (in a batch file)

------- snip --------
@echo off
echo -- Insert filenames into table > do_insert.sql
for %%i in (*.zip) do echo insert into the_table (filename) values ('%%i'); >> do_insert.sql
sqlplus user/password@db @do_insert.sql
------- snip --------

should do the trick

Thomas

Try this:
http://asktom.oracle.com/pls/asktom/...D:439619916584

Try this:
http://asktom.oracle.com/pls/asktom/...D:439619916584

Try this:
http://asktom.oracle.com/pls/asktom/...D:439619916584

Try this:
http://asktom.oracle.com/pls/asktom/...D:439619916584