Re: Extended Procedures with 8i Client

Its probable that your tnsnames.ora and listener.ora have not been configured correctly.
There is a document on oracle MetaLink about 'External Procedures' which tells you about possible causes for that error. Also, there are a few things between the tnsnames and listener ora files which need to be 'in sync' with each other.

Also, is oracle installed on your client machine? If you are connected to your local installation, external procedures needs to be set up on the client as well.

Mark

In article <40Y14.74877$5W2.2080175_at_news6.giganews.com>, "Brad J Smith" <bradsmith_at_delriotech.com> wrote:
> I am attempted to execute a stored procedure (from a client
> machine) that
> import images into an 8.1.5 database. This procedure uses ORDSYS
> objects
> that are apparently located in extended procedures. When
> executing from the
> client (not the server), I am receiving an ORA-168575 error
> stating that
> Oracle cannot open an RPC connection. Any clues?

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!