Re: Problem of executing DBMS_LOB and UTL_FILE

Interesting problem. I'd expect it to work, have done similar things in the past.

Could you paste the exact error code and message?

M

wucf_at_hotmail.com (Michael) wrote in message news:<d08d4e18.0205071921.24315e75_at_posting.google.com>...
> 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
Received on Thu May 09 2002 - 12:05:45 CEST