Re: Invalid directory path / service name

diego.carpintero_at_eu.dendrite.com schrieb:

> Thanks for your answer
>
> > Question: did you verify the directory path?
> yes
>
> > Question: did you run the stored procedure when you got the error on
> > the client? Where do you think the stored procedure runs?
>
> Yes, by using TOAD, I did: execute package.procedure();
>
> I think, that the stored procedure runs on the server.
>
> > Did you look up the error in the Oracle Server messages manual?
> > What does it say?
>
> ORA-29280: invalid directory path
> Cause: A corresponding directory object does not exist.
> Action: Correct the directory object parameter, or create a
> corresponding directory object with the CREATE DIRECTORY command.
>
> > Why do you think it has something to do with the Service *name*?
>
> I thought it was possible to assign permissions to a service name.
>
> > Are you running Oracle on the server as local administratror, using
> > the SYSTEM account. This is the only correct method., It will also
> > give you all privileges on all files on that server.
>
> I think so

Well, by using DIRECTORY objects it works quite fine. Many thanks Received on Fri Jun 09 2006 - 04:40:25 CDT