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
Satya
Messages: 36
Registered: January 2001
Member
Any one knew, how to load data from a text file to oracle tables using Pro*C.

Thanks in advance.

Satya
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: 4557
Registered: April 1998
Senior Member
Hi,

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.

Frank
Re: Loading data using Pro*C [message #94349 is a reply to message #94101] Tue, 24 August 2004 00:54 Go to previous message
Dheeraj
Messages: 6
Registered: November 2001
Junior Member
Hi,
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: Fri Sep 21 10:57:42 CDT 2018