Problem with sqlloader [message #69508] |
Wed, 23 January 2002 09:25 |
Godwin
Messages: 37 Registered: January 2002
|
Member |
|
|
Please can anyone help me!
I have my text file saved in Notepad as
'mydata.txt' and contains
10018506,2001,"1",80
10018507,2001,"2",65
I then create a control file as
'control.ctl'
load data
infile 'c:mydata.txt'
append
into table_a (iahstno,iahcyr,iahbc,iahexm1)
Now after i have run the sqlldr at the DOS prompt as
c:ora95po>sqlldr dpc/stud control ='c:control.ctl'
I recieved the message that '2 logical records commited'
But after i logged on to the sql environment and select
all the rows from table table_a, i didn't get the actual records in the mydata.txt file, instead i had in the table the ff records:
1 0 0 0
1 0 0 0
what is cause of the above? Or is there a better steps to follow since i followed FAQ step by step Oracle SQL*Loader.
My second question is that i called an sql procedure in a form so that it will select records from a different table into another after which it should commit it. Although the procedure runs successfully,i have a problem such that anytime i close the form the message comes up that 'do u want to save changes' and if i accept Yes the error comes that it is unable to save changes.
Is there a way out?
|
|
|
|