UTL_DBWS and UTL_HTTP Packages installation
767685Oct 23 2012 — edited Oct 25 2012Hi,
In order to use Oracle web services, execute permissions need to be granted to users. I have queried dba_objects to see whether they already exists in the DB. I found that UTL_HTTP exists but UTL_DBWS does not.
Can you please elaborate how I can install UTL_DBWS package in SYS schema and then give access to public for example.
DB=10.2.0.4 on RHLinux 5
In one of the related link I found loadjava -u sys/password -r -v -f -genmissing -s -grant public dbwsclientws.jar dbwsclientdb102.jar command to load. little confused about -- download latest copy of .jar file from OTN and then load in the SYS schema or any other schema (http://www.oracle-base.com/articles/10g/utl_dbws-10g.php)
Is it also necessary to create the following as from the above link:
CREATE OR REPLACE FUNCTION add_numbers - -
Thans a lot.
Best Regards