| pl/sql concurrent program-no data found [message #326847] |
Thu, 12 June 2008 18:24  |
deal_my
Messages: 7
Registered: June 2008
|
Junior Member |
|
|
hi all,
I have an concurrent program with pl/sql stored proc as executable.
when i run the query with same parameters in toad everything goes fine, but in apps i couldnt get any data
did any one use a for loop cursor with pl/sql stored proc for conc prog??
any suggestions would be of great help
thanks,
deal
|
|
|
|
|
|
|
|
| Re: pl/sql concurrent program-no data found [message #327014 is a reply to message #326962] |
Fri, 13 June 2008 07:03  |
deal_my
Messages: 7
Registered: June 2008
|
Junior Member |
|
|
I have given errbuf,retcode.
cmng to the paramerts is it like the order in which we give i/p params in proc and order of params in conc prog be same?
actually whts happening is i have for loop cursor ...
all the fnd_file.output given abouve the for loop cursor to display headings is doing fine...but somehow i think its not getting into the loop to fetch and disply data.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
