Oracle Reports integration with Sybase


1) Does Oracle Reports support access to Sybase Database?
2) Is it posible to generate Adhoc reports through Oracle Reports Writer?
3) Is ii possible to execute stored procedures in database from Oracle Rreports?
Thanks in advance!


1)Yes, JDBCPDS feature in Reports 9i support access to Sybase Database. It allows to access different
data sources through JDBC-Drivers. JDBC Driver type "sybase-merant" can be used to access to Sybase Database.
Both SQL Query or Stored Procedure can be used to data source to create JDBC Query.
Please refer to the Online help of the reports Builder for JDBC query. You can also get more details from
"Builing reports" manual at
3) Assuming you are refering to executing stored procedures in sybase database, JDBC query (JDBCPDS) can
be created against Stored Procedure on sybase database which return set of rows.
Oracle Reports Team

November 30, -0001

Oracle Reports integration with Sybase

Hi, 1) Does Oracle Reports support access to Sybase Database? 2) Is it posible to generate Adhoc reports through Oracle Reports Writer? 3) Is ii possible to execute stored procedures in database from Oracle Rreports? Thanks in advance!Keten 1)Yes, JD

Oracle Reports Integration with JDeveloper

Hi Gurus, We have our Oracle Forms Applications 10g Release1 running on the Application Server 9.0.4. I have understood that using oracle Forms Faces, the existing Forms can be brought into the J2EE Frame work developed using ADF Faces. Now my questi

SSRS 2012 report integrated with SharePoint 2013 issue :Report refreshing after some idle time

we have SSRS 2012 report integrated with SharePoint 2013  , when we click on any toggle item after some idle time of 60 secs and try again to expand another toggle item then  complete report is getting refreshed and  if we are in child report it is r

Why is there still no Reports integration with JDev (9.0.3)

see This doesn't work since the Reports feature disappeared with the 'upgrade' to JDev 9.0.3. When will this integration be reestablished? One step forward and thr

JDeveloper - Oracle Reports Integration

Hello ! Is it possible to integrate reports developed in Oracle Reports (JSP technology) into uiXML (UIX XML + BC4J) pages ? Or I must I use UIX JSP pages ? If yes, how ? Thanks, LucianHello again, Yes, I know that UIX JSP is one of the solutions. Bu

Oracle database integration with SAP PI for high volume & Complex Structure

Hi We have requirement for integrating oracle database to SAP PI 7.0 for sending data which is eventually transferred to multiple receivers. The involved data structure is hugely complex (around 18 child tables) with high volume processing requiremen

Crystal report integration with CRM 7.0

Hi, Guru: I would like to check with you. I need show a demo to integrate crystal reports with our CRM product. I know for CRM mobile (mobile system maintenance), we could have this option. however, my requirement is to seek any other options to inte

Oracle HRMS Integration with Microsoft Exchange Server 2007

I would like to know if it is possible to integrate Oracle HRMS 11.5.10.x with Microsoft Exchange Server 2007 using Microsoft Identity Lifecycle Management (ILM) 2007? Has anyone ever come across something like this and successfully achieved it? Does

Oracle Report Server with Weblogic crash

Hello, I am using Report Server 6i on WinNT and the web server used is WebLogic 6.0.. The reports generated are of HTMLCSS format or PDF format. Cud U please send the replies for the below queries at the earliest.. 1.The data in the generated report

Oracle ERP Integration with IdM 7

Hi Geeks, I am integrating Oracle ERP with IdM7 and when I provisiong for a user its working fine, But when I try to modify the users responsibilities its throwing me an error �AN ERROR OCCURRED MODIFYING USER 'TEST123' ON RESOURCE 'ORA_RESOURCE_ERP'

Oracle Report Hang with error on 11g.

Dear Team, I have following setup:- We are using oracle database 11g R2 Oracle Forms & reports : 11.1.2 O.S : Windows 7 Professional When I log in to forms, I am able to log in successfully, after that when i run the report from forms 11g, i receive

Oracle IdM integration with Microsoft ILM 2007/FIM 2010

We currently have ILM 2007 in our environment with limited usage at the moment. We are looking at purchasing Oracle Identity Manager to implement an enterprise wide IAM solution. We were wondering if it is possible to continue using ILM like a middle

Oracle Reports, Working with User defined template

Dear Ones, I saw the Reports9i online help, there if i want to add my own template to the list of predefined template list , it said to add the template in the following directory:"ORACLE_HOME/REPORT60/ADMIN/TEMPLATE/US" But I am unable to find

Oracle Reports 10g with rwclient

Hi All, I m getting the following error when i try to run the report with rwclient. REP-0177: Error while running in remote server Unable to retrieve a string from the Report Builder message file. REP--1870655474: And i m able to execute the report s

Use Oracle Reports with Jdeveloper 11

Hi, My next question. How to use Oracle Reports with jdeveloper 11. I have more oracle reports (used with a existing forms application) and i need to migrate this application to web-adf application. I think that is very powerful to use this oracle de

OBIEE integrated with Oracle EBS R12

Hi, I have Oracle EBS Vision Instance v R12.1 installed on Redhat 5 and wanted to install OBIEE latest version. Can some please point to system architecture diagram as i am conflicted with installation. I do not have complete idea but writing here wh

Can I use Oracle Report Server to print from APEX? How?

Hello, we have Oracle Application server, Oracle Report server and now we just installed APEX and doing a pilot project. Since we don't have BI Publisher, how can we use our Oracle Report server to print from apex report? Can it be done and if yes wh

Oracle Report Error (string buffer too small) in Portal

Hi, I have registered an oracle report (.rdf) with portal which works fine outside in Reports Builder, but when I try to run it in Portal it keeps throwing this error: SQL-6502: ORA-06502: PL/SQL: numeric or value error: character string buffer too s

Unable to download Oracle Data Integrator-Version

Unable to download Oracle Data Integrator with version this could be resolved ASAP.966234 wrote: Unable to download Oracle Data Integrator with version this could be resolved ASAP.What is the file you are trying to downloa

Integration oracle reports with ADF

Hi All, I am getting error- REP-110: File spare_request.rdf cannot be opened. REP-1070: An error occurred while opening or saving a document. REP-0110: File spare_request.rdf cannot be opened As per Sameh Nassar: Call Oracle Reports From Your ADF App