to follow, share, and participate in this community.
Hi Team, I want to trigger the below query in ODI Procedure but I don't know how to do that since both tables resides on different databases: Query Is: select * from SYSTEMB TRG where not exist... These days I am getting an exception (java.lang.IllegalArgumentException: Session: null does not exist) when I restart the weblogic managed server. I have a work around to get away with this error. I completely delete... Hi I'm using the Eclipse with the ODSI plugins as development guid, and I would like to create a physical data service to a REST Web Service but I only can create a SOAP Web service through the wsdl...my question is.... Hi, I'm new to Oracle ODI. I read that ODI can also support traditional ETL approach as well as ELT. My requirement is I need to load bulk data from flat file to Oracle database. I would like to im... Hi, I am new in Oracle Data Integrator(ODI).I downloaded ODI cook book I started working on them i need the artifacts. I am unable to find out. can anyone help to get the location of all ODI artifacts. Thank... Hi Gurus, I am new to ODI development and administration and currently require some expert's advice. I am using startscen/startcmd command to run a scenario. Although the script works fine and it triggers the ... Hi All, I am using a variable for which the value is given by users in the additional variable tab of scenaio. the process runs successfully sometimes and sometimes it fails with the below error. There is no c... We are looking to tune our LYNXX ODSI production instance to accommodate some memory managed operators threshold we saw this morning. Basically we were getting errors in the logs indicating that “10 memory... Hi All, I am new member to Oracle to Data integrator. This is a simple question but i haven't figure out. I have four source tables and i need to apply joins (left, right and inner)between the table s... Hi, We have one master and work repository created for our environment which uses a single schema user ODI_REPO. If I want to create a new Work Repository, could you please let me know the steps. Thank... Problem Summary --------------------------------------------------- ALDSP: Generate a SQL "IN" clause Problem Description --------------------------------------------------- I would like to know if there i... Is it possible for the ODI agent running on Unix to connect a MS SQL 2008 server using windows authentication. I have added a property in the JDBC URL as jdbc:weblogic:sqlserver://10.2.2.163:1433;AuthenticationMethod=... Hi All, I am getting below error and i tried lot googling but not able to find proper solution. Scenario i am try is : To post the JMS messgae from ODI weblogic domain to the queue on another w... ODSI 10gR3 (10.3) does it work with OSB 11gR1 (184.108.40.206.0) Release? ODSI 10gR3 (10.3) can it be deployed to WLS 11g? HI all, i want by ODI to run a report on obiee, is that possible???? KR. FC Hi Folks, I am trying to map source table with target table in my interface.I have imported KM's (LKM and IKM) required in mapping.This is a particular flat file to flat file mapping.Whether flat file to flat file ma... Hi Folks, Session got started in ODI but it is still showing me errors in execution:- Errors are coming marked in red Errors are like:- 1) ODI-1217:Session ... Hi, We need some help on migrating ODI Topology Physical connections. After migration (import), we have to go to new environment's topology manager to change the connection details. Could you please suggest ... Hi All,
I have an ODSI Project in ODSI 10g R3. I want to migrate it to 11G as we are migrating from 10G to 11G in all other components.
Is there any upgrade version of ODSI available? Or
What is ODI(Oracle ... I am using below procedure.But on execution I got cursor is closed exception.Please help.
c1 out SYS_REFCURSOR,
inDateFromDate IN VARCHAR2,
inDateToDate IN VARCHAR2,