Uderc programming article aggregator sites
Index -> Free Oracle Readings

Free Oracle Readings


Xml Data into Table Within an Oracle Database

With no oracle or database background, I have been tasked to figure out how to analyze reading values within xml files. I initially started by writing c# code to read through the xml files, pull out the values I need and summarize the results. Unfort

Global variables in Oracle 8.1.6 on NT

I am running Oracle 8.1.6 on Windows NT. Does anybody know how can I create and maintain global variables or even constants, so that the same variables and constants could be used by all connections to the database. The main feature is that I can sto

Extracting xmldata from clob field in oracle

I have an xml document stored in xmltype (clob)field in oracle Below is the xml data inside the xml ( I have kind of 300 elements similar to this inside the xml) <ns1:E-I12_IS_13 ObjID="I12" ObjType="e">5437090</ns1:E-I12_IS_1

Pros and cons Oracle vs DB2

Hi, We are studying the possibiliy to change our oracle database to DB2. We need to know if someone made the change and found advantages and disadvantages between the two databases. Our SAP runs on HP-UX and has a lot of  Z developments, we know that

Oracle JDeveloper books

Hi, I want to learn Oracle JDeveloper 10g. Kindly suggest some books / tutorials. Regards BabarHi, are you sure you want to start with 10g and not 11g (which is the latest? Have a look here for 10.1.3 documents: http://www.oracle.com/technetwork/deve

Error while invoking a WS-Security secured web service from Oracle BPEL..

Hi , We are facing some error while invoking a WS-Security secured web service from our BPEL Process on the windows platform(SOA For the BPEL process we are following the same steps as given in an AMIS blog : - [http://technology.amis.nl

Error while running a customize report in oracle ebs

Hi .. can anybody suggest how to solve the follwing error while running a customize report in oracle ebs? XXIFMS: Version : UNKNOWN Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved. Current system time is 03-JUN-2011 11:09:24 +------

HELP! Can not install Oracle 8.1.5 w/ RedHat 6.1!

I can not get Oracle 8.1.5 to install onto Linux RedHat 6.1. The Oracle installation script generates several errors. I have tried several attempts, using different options, but they all generate errors. Please help. The Oracle Installation scripts a

Logical operators in Oracle select query

Hello all, Can i use logical operators in oracle select queries? for 1 and 0 =0 ; 1 or 0 =0 if i have two fileds in a table COL1 have a value of 1010 and COL2 have a value of 0001. Is there any way to use select col1 or col2 from table? where or is a

Strange scenario,Oracle can not display the data in mysql correctly

I use Heterogeneous Service+ODBC to achieve "oracle access mysql"(any other method?),and now i find Oracle can not display the data in mysql correctly: -------mysql------------ mysql> create table tst(id int,name varchar(10)); Query OK, 0 row

SSO to Oracle Forms 6.0 and Oracle Reports 6.0

Hi, Could somebody please explain how I should implement the SSO so that I can log on a forms application? Should I use external partner app. ?? How can I parse the right parameters to the forms server ?? thanks, JeromeHi, Oracle Forms 6i does not su

Oracle, Null and empty Strings

Currently I'm facing problems with a class, which contains a String, which is set to "" (empty String). When the class is persistent, oracle writes null to the table column (which seems to be common oracle behaviour) and when retrieving the clas

Installation Problem on Pentium4 with ORACLE 8.1.7 Client

I tried to Install the ORACLE Client 8.1.7/8.1.6 on Pentium4 with NT platform. On inserting the CD it gave the first prompt and after Clicking the "INSTALL/DE-INSTALL PRODUCTS", system stops. Checking in the TaskManager helps us to know that 'se

Installation problem on AIX ( SAP4.7, Oracle-9i)

Hello Gurus, We are installaing SAP4.7 on AIX with oracle-9i as an database we have completed central instance successfully, while database instance we are facing error I am attaching error log for your referenec error log You entered: /sapcd/oracle9

Installation problem on Linux Slackware 7.1 (Oracle 8i)

I try install Oracle 8i Enterprise in Linux Slackware 7.1 (kernel 2.2.16), but the runInstaller don't work. I read the installation manuals and make all steps, but the runInstaller don't work. I get this message: ./runInstaller The Java RunTime Envir

Goldengate Oracle 11.2 Encrypted tablespace

Please advise why this error is showing and help us on this situation Line: ----- Windows 2008 x64 Oracle x64 Oracle Goldengate x64 ++++++++++++SOURCE++++++++++++++ sql>conn / as sysdba **************CREATE TABLESPACE AND TABLE*****

I am trying to have access tables of the Sql Server through the Oracle

I am trying to have access tables of the Sql Server through the Oracle and this being occurred the error: ORA-28500: connection from ORACLE to a non-Oracle system returned this message: [Generic Connectivity using ODBC][H006] The init parameter <HS_F

Generate xml source file for Oracle Order Capture Print Quote

Hi, I am new to xml and need to work on creating templates for Print Quote. I am trying to generate the xml source file for which I enabled the report in system administrator and set the output to XML and assigned to Quoting Reports responsiblity. I

APiI for generating Quote report as Pdf  in oracle iStore

hi, Any one help me on which API is used for generating quote report in oracle istore...Are u sure about  the report version. Please do upgrade  while  even in oracle  they almost stopped for new version -Developer suiteRead other 2 answers

Unable to load database connector - using JRC w/report connecting to Oracle

A simple Java program was created to test a Crystal Report using JRC. The Java program is a thick-client Swing desktop application (modified from an example of crxi_r2_migrating_rdc_to_jrc.pdf). The program failed to execute the report with the follo