| Batch Discoverer export - revisited [message #392915] |
Thu, 19 March 2009 11:25  |
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  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
