| Passing parameters from windows command line [message #135823] |
Fri, 02 September 2005 13:46 |
jimamj
Messages: 2
Registered: September 2005
|
Junior Member |
|
|
I am new to oracle and discoverer. I have written a few simple batch files to run queries. I can't seem to get a paramater to pass through. I am concerned with dates primarily. I also wanted to know if you could use sysdate or any other automated date function to dynamically change a query parameter. I know I could calculate the date I need in discoverer, but the reference material seems to say I should be able to do it at the command line. I get this in my log file.
Sheet 1: Unresolved parameter.
I can run jobs on reports without parameters without any problems. This is an example.
/connect user/pw@db
/apps_user /apps_responsibility "ResponsibilityName"
/eul EULName
/opendb "user.reportname"
/sheet 1
/parameter "Schedule Date Min" 01-AUG-2005
/parameter "Schedule Date Max" 31-OCT-2005
/export XLS "C:\etc...."
/batch
Any help would be great. Thanks.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
