I need some help in creating a datawindow through ORACLE stored procedure.
I am using ORACLE 10g as back end and PowerBuilder 8 as Front end for my application.
I have a stored procedure which returns result set through an INOUT cursor populated from a Temporary table. This procedure is returning result set when I execute the stored procedure in ORACLE ISQL* Plus(SQL Plus).
But when iam creating a grid datawindow with this stored procedure, PowerBuilder is throwing the following error message.
“Cannot create DataWindow.”
“‘Arguments for select are invalid or incomplete’ ”
Can any one suggest the solution for this problem?