pls/sql help please

From: Eugene Pipko <eugene.pipko_at_unionbay.com>
Date: Thu, 28 Jan 2010 10:36:49 -0800
Message-ID: <34DB87F47199374280ADFD2968CDBCFA88160347A4_at_MAIL01KT.seattlepacificindustries.com>

Hi all,
I have the following line in the file in the text file being sent to me (just an example):

x                                              16         18         20         22         24                     <- tab (hidden)

Very last character on that line is TAB character. I am trying to account for that, but for some reason can't catch it:

vSize_field := TRIM(SUBSTR(vLine,C_SIZE_FIELD_START,C_SIZE_FIELD_LEN)); vSize_id := sc_get_size_fn(vSize_field,' ');

WHILE ( vSize_field IS NOT NULL OR TRIM(vSize_field) <> ' ' OR TRIM(vSize_id) <> CHR(9) ) LOOP

• store values in collection vNext_row := NVL(sc_size.LAST,0)+1; sc_size(vNext_row) := vSize_id;
• progress down the line C_SIZE_FIELD_START := C_SIZE_FIELD_START + C_SIZE_FIELD_LEN;
• retrieve current values vSize_field := TRIM(SUBSTR(vLine,C_SIZE_FIELD_START,C_SIZE_FIELD_LEN)); vSize_id := sc_get_size_fn(vSize_field,' ');

END LOOP; What am I missing?
Thanks,

Eugene Pipko
Seattle Pacific Industries
office: 253.872.5243
cell: 206.304.7726
P Please consider the environment before printing this e-mail

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jan 28 2010 - 12:36:49 CST