top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

informatica +pl/sql, working with function and reference cursor

0 votes
404 views

I have a package and I have to execute a function from package whose parameter is session date and return value is a reference cursor. When I connect to database and execute the function, I am getting proper output. When I am executing the same in informatica, it's going wrong at date part. 1) Firstly what can be an approach to execute the function and obtain the data in informatica 2) is this possible by source qualifier transformation or SQL transformation? 2) if there is feasibility how can I pass the date to Oracle

posted Feb 4, 2015 by Sachin

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

A cursor is a pointer to a private SQL area that stores information about the processing of a SELECT or data manipulation language (DML) statement (INSERT, UPDATE, DELETE, or MERGE). Cursor management of DML statements is handled by Oracle Database, but PL/SQL offers several ways to define and manipulate cursors to execute SELECT statements.

Please refer this link for more information about cursors:

http://www.oracle.com/technetwork/issue-archive/2013/13-mar/o23plsql-1906474.html

answer Feb 5, 2015 by Shweta Singh
Similar Questions
0 votes

I am setting up a dev environment for a project, with informatica 9.1 and SQL Server 2012 on a Windows Server 2008 R2 machine.

Installation etc has finished fine and no issues reported so far.

When we are trying to run our first mapping/workflow, the SQL Server database connectivity is becoming a bottleneck.

I tried creating a native connection to SQL Server, and also odbc, both don't seem to work, the session in question just fails to initialize. The error message finally is

failed to prepare session

Am I missing something here? Any experiences?

Disclaimer: This is my first ever attempt to host Infa repository at SQL Server, and also, using source and target as SQL Server.

0 votes

I have found the mapping sdk code samples, however without any documentation whatsoever.

Currently working with 9.0, I am looking for more info.

For one of the current issues, when I try to save the mapping to repository, (with pcconfig.properties lying in the same folder where the xml file is being generated), I am getting the following error:

Written the file..

Caught an exception in run() method

java.io.IOException: Cannot run program ""C:\Informatica\pmrep"" (in directory "C:\Informatica"): CreateProcess error=2, The system cannot find the file specified

java.io.IOException: Cannot run program ""C:\Informatica\pmrep"" (in directory "C:\Informatica"): CreateProcess error=2, The system cannot find the file specified

com.informatica.powercenter.sdk.mapfwk.exception.MapFwkOutputException: Error saving to repository :  Failed to connect to repository

    at com.informatica.powercenter.sdk.mapfwk.xml.XMLWriter.save(Unknown Source)

    at com.informatica.powercenter.sdk.mapfwk.repository.Repository.save(Unknown Source)

    at TestRaghavExample.generateOutput(TestRaghavExample.java:259)

    at TestRaghavExample.create(TestRaghavExample.java:64)

    at TestRaghavExample.main(TestRaghavExample.java:272)

Caught an exception in run() method
This is my initial example.. trying to find my way through the API..

+1 vote

I have installed Informatica 8.6 on Vmware and SQL Server 2008 R2 installed on my local host. I am not able to connect the Informatica with SQL Server 2008 R2.

Kindly help me as soon as possible.

Thanks in advance

...