Hi,
I am trying to call an Oracle 10g stored procedure from PowerBuilder Vr 11.1 and I can't get it to work.
Below is my code. When I run my application, the first call to Execute statement returns SQLCODE = 100 and Fetch returns -1.
The second call to the Execute returns SQLCODE = -1 and Fetch returns -1.
I can't get the procedure to return any data.
Any help would be greatly appreciated.
----- Power Builder Code ----------
DECLARE GetData PROCEDURE FOR PARKING.P_Get_data (:p1 ,:p2) /* input params*/
Execute GetData ;
FETCH GetData INTO :P3, :P4; /*output params*/
IF SQLCA.SQLCODE = 100 THEN
Messagebox ("FYI", "SQLCA.SQLCODE = 100")
elseIF SQLCA.SQLCODE = -1 then
MessageBox("Ooops","SQLCA.SQLCODE = -1", StopSign!)
Else
Messagebox ("OUTPUT value for P3 is: ", P3 )
END IF
Close GetData;