We have a requirement to download data from SAP system to our Oracle DB. Issue is we will not be able to connect to SAP DB. They will provide a webservice and we should use that by passing parameters. My query is, how can we do that in Oracle DB. I want to write a Program unit and call web service whenever required.
View 5 Replieswhy the link provided under the How to Build an Access Control Page Download Spreadsheet Data Download the following *.csv file to your local system: In your Web browser go to:
[URL]............
returns nothing for me!
I need to extract tag values from REST web service response.
Webservice response
Quote:
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
- <LicenseDetailsRes xmlns="com:*******services:LicenseDetailsRes">
<ResponseCode>LD001 - SUCCESS</ResponseCode>
<OrderNumber>51663852</OrderNumber>
<LineNumber>8</LineNumber>
<quantity>0</quantity>
</LicenseDetailsRes>
I am storing above response in a table column 'output_xm' of xmltype datatype.
My requirement is to extract 'ResponseCode' & 'quantity' values from above response. For which I am using below query but it's not working.
SELECT x.order_number
,x.line_number
,x.tnc_pid
,EXTRACT (VALUE (d), 'LicenseDetailsRes/ResponseCode/text()').getstringval () status
,EXTRACT (VALUE (d), 'LicenseDetailsRes/quantity/text()').getstringval () pak_quantity
FROM xxcfi.xxcfi_vt_tnc_pak_details x
,TABLE (XMLSEQUENCE (EXTRACT (x.output_xml, '/LicenseDetailsRes'))) d
WHERE x.order_number = 50403901
AND x.line_number = 2
AND x.tnc_pid = 'R-LMS-4.0-100-K9';
I am trying to connect to Oracle 11g using ODBC.I created a data source name from Admistrative Tools->ODBC Data Sources.I selected Oracle in OraClient11g_home1 as the driver. I tested the connection and it was succesful.I tried to connect from visual studio. I used the Data Source as Microsoft ODBC Data SOurce. Selected my DSN from drop down (LORAC). I gave the user name and password and got the followign errors:
ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
This is my tnsnames.ora located in C:oracleproduct11.1.0client_1
etworkadmin directory.
# tnsnames.ora Network Configuration File: C:oracleproduct11.1.0client_1
etworkadmin nsnames.ora
# Generated by Oracle configuration tools.
LORAC =
(DESCRIPTION =
[code]...
When i do tnsping LORAC, i get OK. When I do tnsping of the other service name i get Failed. However when I try to connect to that service from Visual studio I get a differnt set of errors:
ORA-12154: TNS:could not resolve the connect identifier specified
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
I had assumed that as the test connection from ODBC Administrator had worked I would be able to connec to my database from viusal studio. Is there something wrong in my tnsnames.ora? The content or its directory location?
We are trying to configuration the Dataguard in Oracle Database 10g Enterprise Edition Release 10.2.0.1.0. While we check the lsnr configuration the following error has occured.
SQL> select name from v$database;
NAME
ACCLDATA
SQL> select status,error from v$archive_dest;
STATUS ERROR
VALID
ERROR ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
INACTIVE
INACTIVE
INACTIVE
[code]...
I'm studying to 1Z0-052 and i want to know where can i download the OUI for oracle 11g.Actually, i'm using this oracle version:URL....Also, oracle site has this: URL.... Where can i download the OUI Installer? or am i using the correct one?
View 1 Replies View Relatedfrom where I can download Oracle9i ?
View 2 Replies View RelatedCan I download & use a version for a Mac using OS X 10.4.11?
View 1 Replies View RelatedI needed to use oracle 10g R2 (for any of following platforms : Windows 7/2008/Linux) as I am preparing for my 10g DBA OCP certification. But when I go to Oracles site for download it shows only the 11g not 10g.
View 46 Replies View RelatedI am working on Oracle Developer (Forms/Reports). I want to learn Oracle BI Publisher 10.Whenever i try to download BI Publisher 10 (Win 32 bit) from the below link,
[URL]....
it stops after about 30 minutes. As per the the Internet speed it takes about 45-60 minutes to complete such file.I tried multiple times but not able to download this file.
I need download the Oracle 10g to do some migration tests, but isn't not available in oracle website.
View 1 Replies View Relatedi just bought the oracle scripts from rampant. any know how long will it take for me to get the download link. for these scripts...
View 3 Replies View RelatedProvide me links for Oracle 9i forms to download. i am unable to find in Oracle site.
View 1 Replies View RelatedI want to download SUMMIT schema .I searched it on net but failed to find it . I also Visit oracle Website ,but its not availabe there also . URL.....
View 2 Replies View RelatedI'm in need to download the older version of Oracle Database 10g (10.2.0.5). How to do it? I have tried to talk through the Live Chat and through Oracle Support Phone but I cant get an answer from them. Why has this suddenly been done this hard :(?
I should have saved the installer.
i am looking for a free download by oracle meant specifically for Linux. i am using fedora core 5 32 bit version of Linux.
View 1 Replies View RelatedI want download latest critical patches of 11.1.0.7.0, 11.1.0.6.0. how can i download
View 1 Replies View RelatedI use Oracle database 11g. How can download file and save in path on database server? in other words I have URL for file saved on anther serve I want to download and save on Database server.
View 4 Replies View Relatedi have aprocess that generates a textfile using utl_file but i need that file in the client pc.
is there a native method like as_to_client that i could use to copy this file in any client machine without the need of install an extra software in client pc
I must setup RAC 11g but I haven't meta link account to download cluster ware.
View 2 Replies View RelatedI am trying to download Oracle BAM 10g but it seems that the link is broken and when i click on the file to download it takes me back to the same page i was on;
the page with the link is
[URL]........
My company has acquired a technology that was written in Oracle Forms 6-8 and am looking to first compile and maintain and then upgrade to either 11g or another platform. The older versions of Oracle Development cannot be downloaded from Oracle's site. Will Oracle provide the link if asked?
View 5 Replies View RelatedI need to limit the usage of the CSV download to some users : how can I do that ? Is it possible to connect CSV download to a custom button ?
View 4 Replies View RelatedI have database 10.2.0.3 with one procedure that calls some java class loaded in database. Unfortunately I don't have source code of that java class or whole jar that was loaded into database.I would like to download it from database and try to decompile it.
how can I download some java classes from database? Everything I know is only the name of some java class that is used in one PL/SQL procedure (CREATE OR REPLACE PROCEDURE ..... AS LANGUAGE JAVA).
I am migrating my application from Apex 3 version to Apex 4.0.2. In previous version , downloading a file was working fine.
But now, it is not working..Is there any changes to be done with the properties?
I was using wpg_docload.download_file to download the file.
I encountered problems when installing Oracle 11g. The problem comes from Enterprise Manager. After searching online, I find there is an official solution path patch 8350262 for this. But I cannot find how to download or get that patch.
View 2 Replies View RelatedURL.....Where can I download Oracle database express edition for x86 Linux? I can only see Windows and x64 Linux in Oracle's download page URL....
View 2 Replies View Relatedwant to download full oracle 10gR2 documentation. I also navigated on [URL] but this link allowing me to download pdf one by one but I want to download all pdf's in single shot.
View 2 Replies View RelatedWhere to download the oracle software for building a production server? What are steps ?
View 1 Replies View Relatedfrom where I can free download Oracle 9i Forms And Reports.
View 2 Replies View Related