Search results for query: *

Hey harebrain, karluk, Santa, and anyone else, I've been looking into bind variables whenever I can in my spare time. Lately, I've been given some higher priority tasks at work. Anyway, I can't find any examples of people declaring them in control files. All of them tell me to define the...

Sweet! That makes a whole lot of sense about declaring the variables. I should have realized that. I had briefly thought about that, but I thought maybe Oracle allowed on-the-fly variables to be declared and initialized. I'll give that a shot later today when I get done working on some other...

Hi guys, Thank you for all your replies. I'm glad everyone is in agreement on Harebrain's idea. I've tried Harebrain and Karluk's suggestions (SS where appropriate, differently named bind variables, and both millisecond formats). I seem to be having problems with the bind variables still. I...

OK - I tried Santa's method. That didn't work either. Here's the modified tab-delimited .txt file 820 1400 1 2008-12-15 17:00:00 2 Y 5 Y 1 2008-12-15 7:00:00 477 2009-2-11 12:05:00 1 821 1401 1 2008-12-17 16:45:00 2 Y 5 1 Y 1 2008-12-16 7:00:00 477 2009-2-11 12:05:00 1 822 1402 1 2008-12-22...

Thank you Santa and harebrain. For the moment, I've tried harebrain's method. The input data came from an Excel file that was generated by a script from someone else. I'll probably be getting more Excel files like this in the future. Anyway, the use of a bind-variable to explicitly convert...

I had a feeling I had forgotten something........ Here's the tab-delimited file: 802 1400 1 12/15/2008 5:00 PM 2 Y 5 Y 1 12/15/2008 7:00 AM 477 2/11/2009 12:05:00.000 PM 1 803 1401 1 12/17/2008 4:45 PM 2 Y 5 1 Y 1 12/16/2008 7:00 AM 477 2/11/2009 12:05:00.000 PM 1 804 1402 1 12/22/2008 5:00 PM...

I've been pounding my fists trying to solve this problem. I'm simply trying to take an Excel(Office 2000) file and import it into a table within Oracle. I'm using 10g client and Toad 9.7.2.5. I've converted the .xls file into a CSV file and a tab-delimited txt file and tried to import both(on...