Do not use on any
shared computer
August 30, 2008 03:30am pdt
 
[x]
Attachment Details

UNIX - Uploading data using SQLPLUS

Zone: Unix Operating Systems
Tags: UNIX - Uploading data using SQLPLUS
I'm trying to upload the tab-delimited data in sample.txt (attached) into an Oracle DB table called "tblTemp".  "tblTemp" has 7 fields, named "Field1", "Field2", ......."Field7".

The problem I'm encountering is that the attached code is only uploading the first record in "Sample.txt", and then the program ends.  

Can anyone see something wrong with my code?
Attachments:
 
sample.txt (28 bytes) (File Type Details) 
Sample Data
 
 
UploadClarityDataToLawsonGL.txt (5 KB) (File Type Details) 
Program
 
Start your free trial to view this solution
Question Stats
Zone: OS
Question Asked By: jdhindsa
Question Asked On: 07.16.2008
Participating Experts: 3
Points: 500
Views: 0
Translate:
Loading Advertisement...
 
[+][-]Expert Comment by peter991
Expert Comment by peter991:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
[+][-]Author Comment by jdhindsa
Author Comment by jdhindsa:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
[+][-]Expert Comment by peter991
Expert Comment by peter991:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
[+][-]Author Comment by jdhindsa
Author Comment by jdhindsa:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
[+][-]Expert Comment by xeryi
Expert Comment by xeryi:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
[+][-]Expert Comment by ahoffmann

Rank: Guru

Expert Comment by ahoffmann:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
[+][-]Expert Comment by peter991
Expert Comment by peter991:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
[+][-]Author Comment by jdhindsa
Author Comment by jdhindsa:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
[+][-]Expert Comment by ahoffmann

Rank: Guru

Expert Comment by ahoffmann:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
[+][-]Expert Comment by peter991
Expert Comment by peter991:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
Loading Advertisement...
20080723-EE-VQP-34 / EE_QW_2_20070628