How to Invoke Oracle report builder installed on a server from a client

Advertisement

Hi,
I am using rwrun60 command to invoke report builder through a shell script. In this case the report builder is installed on the same machine where the shell script exists.
But now i have shell script which is on different server (say, Server1) and Report builder is on Server-2. How do i handle this?
the current piece of code i am using in the shell script is:
rwrun60 module=${UNCPATH}/${REPORT_DIR}/purchase.rdf userid=$DBID/[email protected]$DB paramform=NO batch=YES destype=File desformat=pdf desname=${SENDFILE}
Your help will be invaluable...

Advertisement

Hi Denis,
I used both rwrun60 & rwcli60 commands as below:
rwrun60 module=${UNCPATH}/${REPORT_DIR}/abc.rdf userid=$DBID/[email protected]$DB EXPRESS_SERVER="server=Server123/domain=xyz/user=myname/password=password123" ERRFILE=${UNCPATH}/${DIR}/error_test.txt paramform=NO batch=YES destype=File desformat=pdf desname=${UNCPATH}/${SENDFILE}
rwcli60 module=${UNCPATH}/${REPORT_DIR}/abc.rdf userid=$DBID/[email protected]$DB EXPRESS_SERVER="server=Server123/domain=xyz/user=myname/password=password123" ERRFILE=${UNCPATH}/${DIR}/error_test.txt paramform=NO batch=YES destype=File desformat=pdf desname=${UNCPATH}/${SENDFILE}
When i run the shell script file on the command prompt, all i get is this error:
rwrun60: test_outapp 42: not found
42 is the line number of rwcli60 command in the shell script file.
I verified and test_outapp.ksh file is present in the path specified..... even then why this error?...something wrong with the above code?

November 30, -0001

How to Invoke Oracle report builder installed on a server from a client

Hi, I am using rwrun60 command to invoke report builder through a shell script. In this case the report builder is installed on the same machine where the shell script exists. But now i have shell script which is on different server (say, Server1) an

How to start Oracle Report Builder in Linux

Hi all Can someone please help by telling how can i start Oracle Report Builder in Linux???? Thank you and best regards to allHello, there should be a script rwbuilder.sh in ORACLE_HOME/bin for 10.1.2. in ORACLE_INSTANCE/config/reports/bin for 11g Of

How to invoke crystal reports from Oracle forms 11g R2 along with passing p

How to invoke crystal reports from Oracle forms 11g R2 along with passing parameter to it. how to pass parameters to crystal report, please help.how to pass parameters to crystal report, please help.This would entirely depend on crystal reports and y

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

Exception while opening a JSP file created using oracle report builder

I have created a JSP page which contains embedded Oracle reports build using Oracle Report Builder. I have deployed the JSP created above to the Oracle Application Server but when i try to open the JSP file it gives the following error: 500 Internal

Requirement with Oracle report builder

Hi All,, I had a requirement like this...i am very new to Oracle report builder tool and Oracle APPS i need to develop a sample report in this format.......please help me which tables i need to use?? i know how to create user parameters,field columns

ORACLE reports Build 10g - Data Model - query - If statement in Alias ?

I have the following select statement. It has the alias Survivors, Deaths and "All With the ORACLE reports Build 10g - Data Model - I have the following query statement. I require the alias to change. Can the following be done. Cases". Is it pos

How to send the report output to the application server in a excel file

Hello, how to send the report output to the application server in a excel file. and the report runs in background. Thanks in advance. SundeepDear Sundeep. I'm providing you with the following piece of code ... Its working fine for me ... hopefully it

How to install oracle report builder in windows 7

Hi Team, Could you guide me to install oracle report 11g in my PC . Previously i was using 10g . OS : win 7 DATABASE : 11gFollow How to install forms builder? | Oracle Community Hope read all and give a try. HamidRead other 2 answers

Forms/Reports Builder Install

How do I install just application development tools (Forms Builder, Reports Builder etc.) on my NT box? They come bundled within the actual Forms/Reports server CD. When I run the installer the first thing I'm asked is to specify a new Oracle home wh

How to invoke Oracle Workflow software

Hi there, I have successfully installed Oracle Workflow software in my mac laptop. Don't know how to invoke the software. Getting the following exception. sivanantham-kandans-Computer:~/9iR2/orahome/bin oracle$ wfresgen Usage: wfresgen [-v] -f <resou

Error when open Oracle Report Builder 10g (Windows 7 Ultimate 32-bit)

Hi all, I installed Oracle Developer 10g on windows 7 ultimate 32bit. Form builder running well, but the report got problem when i opened. This is the error message: Problem signature: Problem Event Name: APPCRASH Application Name: rwbuilder.exe Appl

How to connect Oracle Form Builder - Oracle Developer Suite 10g - Windows 7

Hi brothers and sisters, Hope all you are fine. I have installed Oracle Developer Suite 10g on Windows 7 successfully and it is working properly. But when I connect to Oracle Form Builder using Connect window asking: a. User Name b. Password c. Datab

How to run Oracle Reports 6i

Can any 1 pls help how to execute the report from plsql or scheduled job and not from a form I have a report that works fine, The concern now is that somebody will have to manually run this process. It should be something automated, wherein it will r

How to Run Oracle Reports from the web.

How can we run Oracle Reports from the web - for example from a portal such as "Gateway" This is a univeristy that implements Banner - so can we run them from within Banner?Yes, of course. And for running the reports-server you need an OAS. Mayb

How to find Oracle drivers are installed in WAS

Hi I am doing Proto type application using webdynpro.I want to create tables in Oracle database,because WAS is installed on Oracle.Now i went to Visual Admin tool and checked the "JDBC Connector" properties.I tried to create the new 'DataSource&

How to convert Oracle reports into excel?

How can we convert Oracle reports into excel. i know there was a thread on this topic which i am not able to find. give the link / help.I found Std Oracle Report output to Excel Sheet has some suggestions. Not being a Reports person anymore I am not

How to call Oracle Report 6i from a java swing/ejb codes (client server)

Hi to all. We now have to do reports using Oracle Reports that have to call from Java Swing (interface) / EJB (Backend). How can we call the Oracle Reports 6i from Java Swing? Do anybody done that?...Any ideas? Where should we find the resourse, if a

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

How to call Oracle Reports via Java Web Application ?

Dear All, I have developed a web reports using Oracle Reports 11g and would like to display these reports via Java Web App that will call them. Kindly help me in this matter. Regards, Irfani will go as John suggested.........Construct a URL with requ