Unable to obtain SP parameters from database

[mucnivasun]

Hi All,
Currently we are using PB7.0 for our application. We plan to upgrade it to PB11.5. After upgrade, no datawindow are retrieving the data. When I try to create a datawindo with store procedure as datasource, I am getting the below message.
Unable to obtain SP parameters from database

Note: We are using Oracle 10g as backend.

Kindly help me to proceed further. Else our firm will go for rewrite in .Net.

 

[thekl0wn]

Is this just for SP DW's? Or does it affect SQL SELECT DW's as well?

 

[mucnivasun]

I could create a datawindow using sql select...But while using stored procedure for datasource, no SP is listing and it shows the above message

 

[mbalent]

Check the database drivers. PB gets its info on stored procs by issuing a call to them.

Matt

"Nature forges everything on the anvil of time

 

[miguelleeuwe]

checkout this link:

http://brucearmstrong.sys-con.com/node/42529/mobile

regards,
Miguel L.