| utl_file error [message #98377] |
Mon, 30 August 2004 05:01  |
rajesh
Messages: 173
Registered: November 1998
|
Senior Member |
|
|
Hi,
Whats the problem with this program
I am grtting the rror
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "SYS.UTL_FILE", line 101
ORA-06512: at "SYS.UTL_FILE", line 157
ORA-06512: at line 8
sqlplus $DB_USER/$DB_PASSWORD <<EOF
DECLARE
file_type UTL_FILE.FILE_TYPE ;
dirpath varchar2(50) := '/home/user/';
buffer varchar2(1024) ;
filename varchar2(20) := 'datafile' ;
BEGIN
file_type := UTL_FILE.FOPEN(dirpath, filename,'w');
UTL_FILE.PUT_LINE(file_type,'rajesh');
UTL_FILE.FCLOSE(file_type) ;
END;
/
EOF
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
