Recently, I have created a stored procedure that utilizes dbms_lob
package to load a file on server into CLOB in a table. I can execute
the procedure on the server from slq*plus. But, when I call the
procedure on the client program,like Forms60, client side sql*plus or
TOAD, I got an error and it is related to permission on fileopen
inside dbms_lob package. I used the same database user for both server
and client side. I have tried to use both file locations that are in
utl_file_dir path and DIRECTORY created by DB user. The file access on
UNIX is set to 755 or 777. In fact, the user has DBA privilege.
The same problem happened when I use UTL_FILE pacakge. I can execute
stored procedure on server using UTL_FILE package to create a log
file, but the procedure cannot be called from client side. I know I
cannot call DBMS_LOB and UTL_FILE package directly from client, but
this procedure is on server. Can anyone give me some help and tell me
what cause the problem or what I have missed? What do I need to do so
that I can call it from client side program?
And, similar problem happens to java stored procedure too. I created a
java program to execute OS command and then create pl/sql procedure
for the java program. All file permission reauired is granted for
running the java program. And, I can execute from server side
sql*plus, but not from any client side program call.
Thanks
mike