Home » Applications » Oracle Fusion Apps & E-Business Suite » pl/sql concurrent program-no data found
pl/sql concurrent program-no data found [message #326847] Thu, 12 June 2008 18:24 Go to next message
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 #326858 is a reply to message #326847] Thu, 12 June 2008 20:51 Go to previous messageGo to next message
aryanna
Messages: 44
Registered: July 2007
Member

Hi,

If you have data parameter, then check the date format passing.
Re: pl/sql concurrent program-no data found [message #326962 is a reply to message #326847] Fri, 13 June 2008 04:13 Go to previous messageGo to next message
raju_kamarapu
Messages: 19
Registered: February 2008
Location: KAULAMPUR
Junior Member
HI,

are you giving Errbuf and retcode parameters in plsql program,
and are you giving the parameter in sequence in paramater window,

Please check the sequence.


Raju.K
Re: pl/sql concurrent program-no data found [message #327014 is a reply to message #326962] Fri, 13 June 2008 07:03 Go to previous messageGo to next message
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.
Re: pl/sql concurrent program-no data found [message #327110 is a reply to message #326962] Fri, 13 June 2008 19:08 Go to previous message
deal_my
Messages: 7
Registered: June 2008
Junior Member
hey raj,
thanks for the suggestions...it worked
Previous Topic: Invoice aging seeded report dosnt hav 90 days &above field,how to fetch the same?
Next Topic: APS DBA, DBA, SYSADMIN Role
Goto Forum:
  


Current Time: Fri Dec 09 12:05:21 CST 2016

Total time taken to generate the page: 0.14966 seconds