How are Oracle Stored Procedures used as Data Source in DataWindows? 1

[katatagan]

Hi there. I am a PowerBuilder developer and recently we have migrated our Sybase databases to Oracle8i. Our problem is, we cannot use Oracle stored procedures which return result sets. The error says that we need to declare the stored procedures. How can we do this? Please help.

katatagan
Programmer

 

[sunpatil]

try declaring the stored procedure as local external function on the transaction object ( using a user object
of type transaction for SQLCA).