Home » Developer & Programmer » Precompilers, OCI & OCCI » Loading data using Pro*C
Loading data using Pro*C [message #94101] Tue, 17 February 2004 06:10 Go to next message
Messages: 36
Registered: January 2001
Any one knew, how to load data from a text file to oracle tables using Pro*C.

Thanks in advance.

Re: Loading data using Pro*C [message #94106 is a reply to message #94101] Thu, 26 February 2004 04:05 Go to previous messageGo to next message
Frank Naude
Messages: 4569
Registered: April 1998
Senior Member

Write a normal C program to read the text file and include "EXEC SQL INSERT..." statements to load the data into the database. For more info, see the Precompiler FAQ - http://www.orafaq.com/faqpro.htm

Best regards.

Re: Loading data using Pro*C [message #94349 is a reply to message #94101] Tue, 24 August 2004 00:54 Go to previous message
Messages: 6
Registered: November 2001
Junior Member
You can use sql loader also.
or if you use reading from text file and insert with insert statements then u will use varchar variables.and for porting set blank and set proper length before inserting..
Previous Topic: OCILogon - TIMEOUT : HOW TO ?
Next Topic: ORA-12560 TNS:protocol adapter error: -In VB
Goto Forum:

Current Time: Thu Sep 23 06:45:26 CDT 2021