SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can a PL/SQL program read and write file at remote server

cminglJan 20 2010 — edited Aug 31 2011

Hi Everyone,

Is it possible to read and write a file at remote server? I use utl_file_fopen, get_line, put_line and it seem the program can't find the fiile or directory (ora-29283)

Due to our system upgrade, our database server and application server are separated, right now my pl/SQL program could not read the file in the remote server. Our oracle version is 10.2

All the input are greatly appreciate.

Thanks

Kevin C

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 28 2011

Added on Jan 20 2010

#linux, #plsql

16 comments

10,309 views