OraFAQ Forum: SQL & PL/SQL » Nested Table And UTL

Home » SQL & PL/SQL » SQL & PL/SQL » Nested Table And UTL_FILE ??

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Nested Table And UTL_FILE ?? [message #212980]

Tue, 09 January 2007 00:38

oraksa
Messages: 8
Registered: March 2005
Location: KSA

Junior Member

Hi All

i have some questions about Using UTL_FILE Pkg with Nested Table

IF i have created a TYPE and TABLE like this

CREATE TYPE abc_typ AS OBJECT
(nest_col1   number(3),
 nest_col2   number(2),
 nest_col3   varchar2(3 char),
 nest_col4   number(2));
/

CREATE TYPE abc_nt AS TABLE OF abc_typ;
/

CREATE TABLE abc_tbl
(col_1     number(4),
 col_2     varchar2(10 char),
 nest_col  abc_nt)
NESTED TABLE nest_col STORE AS nest_tbl;

the col_1 and col_2 of table abc_tbl will hold values like this

'1234'   'abcdef' one time only

while the nested column nest_col

will hold vlaues like this one

001    Sat    01    20   
002    Sun    02    21   
003    Mon    03    22       this values in text file
004    Tue    04    23   
005    Wed    05    24   
006    Thu    06    25

Now how to use UTL_FILE Pkg to load the DATA to nested table
from the OS text file?

How to create Procedure , so i can use it every time i want to load more data to same table?

thanks

best regards

Report message to a moderator