Hello All,
In my job, I want to run multiple sql queries in oracle stage and pass the output to a sequential file using RCP.
In parallel jobs, I can not provide sql in a file for oracle stage. This option is available with server jobs. This would have been first preference but looks like not possible. Any one know any hidden method to do so?
If not, I need to pass the sql as parameter. My queries will be huge in size. Is there any upper limit on parameter size to type String?
Thanks,
Shashank
Sql query as parameter
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: