Oracle Report Error:


Good morning, All:
I am having to do a quick turn and burn on the use of the Oracle Report Bulder 10g with no prior experience. I am a Crystal Reports and somewhat Cosnos user. I have found the Oracle Report Builder to be pretty easy application to learn and use for fast wizard based reports.
My problem is this:
Program ==>Run Web Layout
And within a Internet Exployer 7 window I get the following:
500 Internal Server Error
OracleJSP: oracle.jsp.provider.JspCompileException:
Errors compiling:C:\Documents and Settings\Administrator\Local Settings\Temp\docroot\3003\default\defaultWebApp\persistence\_pages\\
javac: invalid flag: C:\\Documents
Usage: javac 
where possible options include:
  -g                        Generate all debugging info
  -g:none                   Generate no debugging info
  -g:{lines,vars,source}    Generate only some debugging info
  -nowarn                   Generate no warnings
  -verbose                  Output messages about what the compiler is doing
  -deprecation              Output source locations where deprecated APIs are used
  -classpath          Specify where to find user class files
  -sourcepath         Specify where to find input source files
  -bootclasspath      Override location of bootstrap class files
  -extdirs            Override location of installed extensions
  -d             Specify where to place generated class files
  -encoding       Specify character encoding used by source files
  -source          Provide source compatibility with specified release
  -target          Generate class files for specific VM version
  -help                     Print a synopsis of standard optionsPlease advise and redirect.
[email protected]


ORA-06508 PL/SQL: could not find program unit being called
Cause: An attempt was made to call a stored program that could not be found. The program may have been dropped or incompatibly modified, or have compiled with errors.
Action: Check that all referenced programs, including their package bodies, exist and are compatible.
Ignore my previous suggestion (removing objects), check the following:
Is there any library attached to this report (pll/plx)?
1. If yes, then
-check if library exists on the linux server and preferably in the same folder with reports
-recompile the library
-open rdf file and remove the library
-attach the library again, and make sure you remove the path
-copy the library and report file on linux and run the report
2. If no (no library is attached), then
-are there any database package/function/procedure are being used in the report?
-if yes, then
-check the status of that package/function/procedure
Hope this helps.
Edited by: fs on Nov 24, 2009 1:21 PM

November 30, -0001

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

Oracle Report Error:

Good morning, All: I am having to do a quick turn and burn on the use of the Oracle Report Bulder 10g with no prior experience. I am a Crystal Reports and somewhat Cosnos user. I have found the Oracle Report Builder to be pretty easy application to l

Oracle Reports - Multi lingual pdf - jvm error

Hi all, We are trying to develop a multilingual pdf report in oracle reports 9i. When we do font subsetting or embedding we get the error: stackpointer=3bb03200 JVMXM004: JVM is performing abort shutdown sequence this error is consistent for font emb

Error deploying oracle report JSPs in Jdeveloper.

Hi, I am trying to deploy and run a report created using oracle Report tool(comes with oracle 10g developer suite). I did the below steps. 1. I created a web layout report in oracle reports tool. 2. Open Jdeveloper (which comes in developer suite). 3

Error in running oracle report on APPS due to print style

Hi i have an oracle report which displays about 550 rows of data...When i try to run it with oracle apps i selelect landwide but i get an error as the defined style can not print that much amount of rows.Is there any toher style which prints this man

Dynamic table in Oracle report data model using laxical parameter is giving error Ora-00936: missing expression

Hi , I am using Oracle report 10G And trying to create report with dynamic table SELECT &COL1, &COL2 FROM &TAB If I put this on data model it gives below error ORA-00936: missing expression ==> from Can anybody advise to solve this issue. R

Gettting error while trying to upload an xml in oracle report builder11g

REP-0069: An internal error occured. JDBCPDS-62008 : java.lang.NullPointerException This is the error m getting while trying to upload an xml with the option Open an existing report in Oracle Forms and Reports 11g An xml to be uploaded is as follows

Sum function do not work in oracle reports enhanced spreadsheet format

we are using oracle reports in our oracle application server 10gr2 and we are creating enhanced spreed sheet.And the report opens in MS excel fine.But we can not apply any formula like VALUE,SUM,AVG on that report after opening it into excel

Saving Oracle report to Database

I want to generate report on report but for that, I need to install Oracle report tables to store the report definition. Can anybody tell me where to get script to create those tables. I am using Report 6i on DBMS 8iNo, I heard that the report RDF fi

Using JNI in Oracle Reports

Hi. I have some difficulties understanding the Oracle Reports mechanism of JNI. The problem I have is the report job is crashed when I use the imported java class. I am using Oracle Reports on Oracle Linux The scenario of generating report i

Unable to start Oracle Reports Server for 10g version

Attention Oracle Reports Team or anyone else: I am unable to start the Oracle Reports Server for 10g version of the Application Server. I have included the trace files see below. I marked the text in bold that might indicate the issues. An

Running Web Layout Of JDBC Query in Oracle Report Builder 11g.

javax.servlet.jsp.JspException: REP-4100: An attempt to execute data source failed. JDBCPDS-62008:A SQL error occurred: {0}. S1000 [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt javax.servlet.jsp.JspException: RE

PDF Report Error When Distribute the Output?

REP-0069: Internal Error. REP-57054: In-process job terminated:Executed successfully but there were some errors when distribute the output. REP-50159: Executed successfully but there were some errors when distribute the output. Approximately 5000 Pag

Reports Error Page 10g NullPointerException

We have created a JSP report that produces Excel output via method outlined in the example given in the HowTo: The JSP runs fine under 9.0.2 iAS but when we moved

Oracle reports to XML problem

Hi All, I created raport in RDF and also created RTF file. Concurent request format is XML. Few weeks ago there was not any problem with this raport, but now it ends with WORNING (yellow collor). The error is: XMLParseException: Expected name instead

Oracle Report Server Not Accessible

Hi Folks, I'm facing a series of issues with Oracle reports server 11g. I'l list the issues one by one. 1. I'm not able to start the weblogic server from the domain which i've created for Reports. It gives me authentication error. I've tried clearing

Lexical Parameter in Oracle Reports . . .

Hi all, I am trying to pass a value to a query in oracle reports . . . the use of the parameter is to add 2 additional columns to an existing query, if a bind parameter is set to 'Yes' else the parameter carries a value NULL; Here is the code I have

Using CLOBs in oracle Report Builder

I want to select all the data in a CLOB column using SQL Navigator by just doing select entry_note from chartentries; just as you say in your example by it just gives me back a result of (ORACLOB). If I do select to_char(entry_note) from chartentries

Reporting Error while Restart to apply Recent Changes in OBIEE 11g in EM

Hi Friends, I tried to open my rpd in online mode in OBIEE 11g, For that i went into EM for getting my rpd updated... So after all doing changes, I need to restart for applying changes, so I restarted the system components But only 80% of it started,

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