OraFAQ Forum: Server Utilities » calling sqlldr from my oracle forms

Home » RDBMS Server » Server Utilities » calling sqlldr from my oracle forms

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

calling sqlldr from my oracle forms [message #72421]

Thu, 12 June 2003 03:42

Victoria
Messages: 152
Registered: July 2002

Senior Member

Hi,
How to call sqlloader utility from oracle forms?
I dont have oracle client installed in my machine.
I have only oracle form6i in my machine.

The control files and data files am dynamically creating in my machine.
No manual entry should be involved in this process.So i cant go to unix prompt and execute this sqlloader rather i should click a button in my form and then it should go and load the table.
Here i can use insert into statements,but that is not feasible in this context in my application.
Please guide me~~~~
Thanks in Advance
~V~

Report message to a moderator

Re: calling sqlldr from my oracle forms [message #72427 is a reply to message #72421]

Fri, 13 June 2003 07:12

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

i have no idea about forms (whether it has its own sqlldr or not?).
but you need to install oracle client / server to get the sql*loader executable.
From the client (forms), you can still fork a process to connect to unix server and execute the sqlldr).

Report message to a moderator

calling sqlldr from my drives like c:\ [message #73482 is a reply to message #72421]

Mon, 10 May 2004 02:44

sulaiman tuffaha
Messages: 1
Registered: May 2004

Junior Member

Dear;
How can i entering big collection DB worte in notepad
or a text document separated by the ";" cimicoloms, to my oracle DB.

Report message to a moderator

Previous Topic:	Load Flat file to SQL table using SQL Loader - Very urgent
Next Topic:	Solution to move user objects to new_tablespace

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 01 16:28:34 CDT 2024