This forum is currently locked. You can't register or post questions at this time. (read more)

UTL_HTTP.GET.RESPONSE

All posts relating to Oracle PL/SQL development.

Moderator: Tim...

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: UTL_HTTP.GET.RESPONSE

Postby Tim... » Tue Jan 29, 2013 7:13 am

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...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

venkat
Member
Posts: 30
Joined: Sat Jan 05, 2013 5:13 am

Re: UTL_HTTP.GET.RESPONSE

Postby venkat » Tue Jan 29, 2013 8:20 am

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...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: UTL_HTTP.GET.RESPONSE

Postby Tim... » Tue Jan 29, 2013 9:05 am

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...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

venkat
Member
Posts: 30
Joined: Sat Jan 05, 2013 5:13 am

Re: UTL_HTTP.GET.RESPONSE

Postby venkat » Tue Jan 29, 2013 11:20 am

Thank You
Mr Tim

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: UTL_HTTP.GET.RESPONSE

Postby Tim... » Tue Jan 29, 2013 1:53 pm

;)
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Oracle SQL and PL/SQL Development”

Who is online

Users browsing this forum: No registered users and 0 guests