UTL_HTTP.GET.RESPONSE

[Tim...]

Hi.

No. You can not access files on other machines. Oracle can only access files on its local file system, or those mounted (mapped drive) on the database server.

If the application server is presenting the contents of the jar file as a web service, then you can interact with that web service from the database, but that is not the same as just interacting directly with the jar file.

Cheers

Tim...

[venkat]

Hi,
Mr TIm
Oracle can only access files on its local file system, or those mounted (mapped drive) on the database server.

Bu this Application Server is connected to our database then can we access those Jar Files(Which Are in Application Layer) using PL SQL
From(Data base)
Thanks In Advance

[Tim...]

Hi.

It depends what you mean by access them. Do you mean:

- You are trying to directly access the jar files, like from a file system. No. You can't do this unless you map a drive to it using NFS or Samba etc.
- The jar file is part of an application and the application is running on an application server. You can access the web application from the database.

I don't know how else I can explain this.

Cheers

Tim...

[venkat]

Thank You
Mr Tim

[Tim...]