ScottMattes
Member³
I have a file with dbms_output.put_line in it that I want to load into a table of ( pk, group, line_value ).
I told the TI that I had 3 fields, the first 2 are +0, +0 and the last was +0, CR. Field one uses SQL Function field_seq.nextval, field two uses SQL Function trim( 'value' ) and nothing for the 3rd field. Clicking the Import to SQL and look at it the 3rd field shows ' '.
Sorry, I can't send the file, though I assume that any ole text file will recreate. After I get the file loaded I'll try to recreate with something that I can send you.
I told the TI that I had 3 fields, the first 2 are +0, +0 and the last was +0, CR. Field one uses SQL Function field_seq.nextval, field two uses SQL Function trim( 'value' ) and nothing for the 3rd field. Clicking the Import to SQL and look at it the 3rd field shows ' '.
Sorry, I can't send the file, though I assume that any ole text file will recreate. After I get the file loaded I'll try to recreate with something that I can send you.
