The best solution for me would be that a client application could sent to the server a SQL*Loader statement as if it were a regular SQL statement.
Is it possible?
thanx in advance,
Printable View
The best solution for me would be that a client application could sent to the server a SQL*Loader statement as if it were a regular SQL statement.
Is it possible?
thanx in advance,
I infer from your question that you have files on the server and you want to initiate a SQL*Loader session from the client, right?
One simple methodology is to use 9i's "external table" feature, where the database can execute a query directly against an external flat file, sing SQL*Loader control file format statements embedded in a table definition.
Hi slimdave,
many thanks for your help.
At last we decide to start the process from a main shell script, which is also the most reasonable, who gets the CSV files via FTP, then runs SQL*Loader, and at last runs the PHP-aplication to analiuze the imported data.
We can't use External Tables since we still use Oracle 8.1.7, but that's good to know. I work with 9i in other projects.
The matter came out because we develop on MySQL 4.x, then we'll migrate the DB to Oracle 8.1.7 . MySQL accepts statements similar to the content of a SQL*Loader control file, as if they were SQL statements, being sent from a PHP-application. This does not work with Oracle.
Bye,
Quote:
Originally posted by slimdave
I infer from your question that you have files on the server and you want to initiate a SQL*Loader session from the client, right?
One simple methodology is to use 9i's "external table" feature, where the database can execute a query directly against an external flat file, sing SQL*Loader control file format statements embedded in a table definition.