on 06-14-2018 1:54 AM
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;
Hi Ari,
Are you using the O10 database interface?
Please review the following in the PB 11 doc as to what can be done with result sets.
The below discussion may also help.
https://archive.sap.com/discussions/thread/3607505
Pat
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.