Ask Anantha

ORA-31011: XML parsing failed while calling srw.run_report from database Below is a sample report calling block I copied from Oracle Forums. There was a mistake in the block which was causing the error ORA-31011: XML parsing failed. The solution is simple. the GATEWAY parameter had a 'question mark' at the end of the link. If you see the output generated by srw.start_debugging, the URL framing would be listed there: http://192.168.50.53:7778/reports/rwservlet?&SERVER=rep_dev&report=rep_name&userid=user/pass@sid&destype=file&desformat=pdf&destination=/u01/&distribute=yes If you notice closely there is a & added before SERVER parameter. This is due to the presence of the ? SRW.ADD_PARAMETER of GATEWAY. If you remove the ? from the last of link the report will be invoked. DECLARE v_paramlist srw_paramlist; v_jobident srw.job_ident; v_status srw.status_record;  BEGIN srw.start_debugging; v_paramlist := srw_paramlist(srw_parameter('...

Covering Developer version 9i for Windows NT/2000/XP By Richard Holowczak This tutorial introduces the Oracle9i Developer Suite Release 2 (August, 2002) that includes Oracle Forms 9.0 and Oracle Reports 9.0. The main objectives are to demonstrate and provide hands-on instructions on creating and modifying data entry and query forms in various configurations, reports and graphics. Caveats: Please note that Oracle tends to change things like menu items, prompts and other small things between each major (certainly) and often minor release. Depending on the exact release of Oracle9i Developer Suite you have, you may find some small discrepencies between what is shown in this tutorial and what you see on your screen. Prerequisites Before following this tutorial, a student must have a valid user account in an Oracle server or a local installation of an Oracle database. Contact your DBA or systems administrator to learn the details of how Oracle server is set up in your organization. If yo...

I have never tried this kind of reporting before. Mail from a friend prompted me that I should start creating this report and also publish an article which shows a step-by-step process of creating one. So here is the list that we are going to achieve: Create a DTD file Create an XML file Create a report based on the two files created. First step is to create a DTD file. Our XML file contains details of all database environments in use by a team. The following is our DTD file. Save the following contents as c:\database.dtd:                          , OracleSID                          , DatabaseDomain                          , Administrator+                          , DatabaseAttributes       ...

If you are unable to compile your reports or plls in Oracle 10g Version, due to the error like PL SQL ERROR 201: SRW.___ must be declared, then check the existence of the following file and its privilege: rwrun.jar in /Oracle10gAS/reports/jlib folder. Where Oracle10gAS is the folder where 10g Application server is installed. You will normally get this error only in UNIX/Linux flavors, because this is related to privilege rights. If you are getting this error in Windows also, then it is quietly possible that the file is missing. The file must have the privilege 755 or -rwx-r-x-r-x.