Home » Developer & Programmer » Reports & Discoverer » Batch Discoverer export - revisited
Batch Discoverer export - revisited [message #392915] Thu, 19 March 2009 11:25 Go to next message
mytfein
Messages: 8
Registered: March 2009
Junior Member
Hi Everyone,

I am new to Oracle and Discoverer.

I am having a problem passing a parm.

We are using: 10.1.2.2.48.18

1) how do i check that we have the latest patches?

2) running with multi parms is giving me an error.

3) my command line code:
================

a) it works - no parameters
C:\oracle\BIToolsHome_1\bin\dis51usr.exe /connect mysignon/mypassword@odstest /open c:\ARG_System_front\z090317_CAD_email_needed_columns.DIS /sheet ALL /export XLS "C:\ARG_System_front\test.xls" /batch

b) adding single parameter to (a) works
/parameter "parm_AcademicPeriod" "200820" /export XLS "C:\ARG_System_front\test.xls" /batch

c) but, multiple parms do not work
/parameter "parm_AcademicPeriod" "200820", "200830" /export XLS "C:\ARG_System_front\test.xls" /batch

d) checked query, the condition is set for IN :parm_AcademicPeriod

ERROR msg:
"invalid option "200830" parameter for command parameter in command line"

Something about the second parm does not work..... pls advise, thx, Sandra
Re: Batch Discoverer export - revisited [message #392922 is a reply to message #392915] Thu, 19 March 2009 11:53 Go to previous messageGo to next message
mytfein
Messages: 8
Registered: March 2009
Junior Member
Hi Everyone,

2 more issues, pls:


C:\oracle\BIToolsHome_1\bin\dis51usr.exe /connect mysignon/mypassword@odstest /opendb "OTHERCreator.Reg_CAD.DIS" /sheet ALL /export XLS "C:\ARG_System_front\test.xls" /batch

1) the statement above is to run a report from Discoverer DATABASE. The report was created by another user OtherCreator.
I ran it in a .bat file, and got this error generated in a log####.txt file:

Attempt to open workbook failed.

My colleague gave me access to query, I see it in database query
window.

2) i do not know unix scripting, is there a way to pass the params as variables to this command line sentence?

Pls advise, thx s
Re: Batch Discoverer export - revisited [message #392945 is a reply to message #392915] Thu, 19 March 2009 14:00 Go to previous message
mytfein
Messages: 8
Registered: March 2009
Junior Member
Hi all,

i found a post on another forum

to open query from databas OMIT the DIS extension.

http://kr.forums.oracle.com/forums/thread.jspa?threadID=485687&tstart=659
Previous Topic: session problem
Next Topic: Help with Date Parameters
Goto Forum:
  


Current Time: Thu Mar 28 05:03:46 CDT 2024