| utl_file package over a network [message #371210] |
Fri, 15 September 2000 10:07 |
Keith Cain
Messages: 1
Registered: September 2000
|
Junior Member |
|
|
Oracle 7.345
PL/SQL 2.3.4.5
Windows NT/NT Server 4.x
Wrote a stored procedure to run on a database server and write to a shared directory(/mnm) on an application server across the intranet. Init.ora file has utl_file_dir = *;
System user has change permissions on shared dir of app server; We still get the errors below:
SQLWKS> execute net_ack
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "SYS.UTL_FILE", line 85
ORA-06512: at "SYS.UTL_FILE", line 120
ORA-06512: at "XMSADMIN.NET_ACK", line 6
ORA-06512: at line 2
Here is the procedure we are testing:
DECLARE
v_outfile UTL_FILE.FILE_TYPE;
BEGIN
v_outfile := UTL_FILE.FOPEN('144.229.191.83\mnm','net_ack.txt','w');
UTL_FILE.PUTF(v_outfile,'\nHOWDY');
UTL_FILE.PUTF(v_outfile,'\nHELLO\n');
UTL_FILE.PUTF(v_outfile,'HI');
UTL_FILE.FCLOSE(v_outfile);
END;
Any body have any suggestions?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
