Hi everyone,
v7.3x
insert the data in to the another table....
( v_dir in varchar2, v_filename in varchar2)
v_filehandle UTL_FILE.FILE_TYPE ;
utl_file.file_type ;
cfe.account.acct_number%TYPE ;
cfe.account.acct_internal%TYPE ;
number ;
begin
v_filename, 'r' ) ;
); Open the file to write...
line...
exception
:= instr(v_newline , ' ', 1 , 1) ;
- 2 is for 2nd occurance of ' '....
substr(v_newline,1,v_tab1-1) ;
substr(v_newline,v_tab1+1,v_tab2-1);
v_acctnum , nvl(ga.group_id,'NULL')
group_to_account ga
v_acctnum ) ;
the input file...
declare cursor account_check_cur
account_check_cur ;
%v_groupid ;
utl_file.put_line(v_outfile , 'v_ac') ;
account_check_cur ;
utl_file.INVALID_OPERATION THEN
raise_application_error (-20000,'invalid operation') ;
utl_file.INVALID_FILEHANDLE THEN
raise_application_error (-20001,'invalid FILE HANDLE..') ;
utl_file.READ_ERROR THEN
raise_application_error (-20002,'Reading Error..') ;
utl_file.INVALID_PATH THEN
raise_application_error (-20003,'INVALID PATH ERR..') ;
utl_file.INVALID_MODE THEN
raise_application_error (-20004,'INVALID MODE ERR..') ;
utl_file.INTERNAL_ERROR THEN
raise_application_error (-20005,'INTERNAL ERR..') ;
UTL_FILE.FCLOSE (v_filehandle) ;
errors.... eventhough i have a dir and file and table created already.....
SQL> execute ( 'c:\input_files' , 'internal.dat' ) ;
, 'internal.dat' ) ; end;
ORA-06512: at "CFE.LS", line 73
gratly appricated...
-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Mon Nov 30 1998 - 15:17:19 CST