Symptom
Using Oracle 11 and the ORA driver. When
using a declare and fetch and returning a value into a double, the value is incorrect.
Worked ok in PowerBuilder .NET 12.5.2 and it works ok in PowerBuilder Classic 12.6.
Issue is with PowerBuilder .NET 12.6 version.
The stored procedure that is being used is:
CREATE OR REPLACE procedure myinsert
(p_out OUT NUMBER)
AS
BEGIN
insert into MyTable (num_col) values (temp_seq.nextval);
select temp_seq.currval into p_out from dual;
commit;
end myinsert;
Read more...
Environment
- SAP PowerBuilder .NET 12.6
- Oracle 11
Product
Keywords
pb,powerbuilder,oracle,sp,stored procedure,sequence,double,.net,wpf, CR785767, CR 785767 , KBA , BC-SYB-PB , PowerBuilder , Bug Filed
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.