SAP Knowledge Base Article - Preview

2184313 - DB fetch into double returns incorrect value - SAP PB

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

SAP PowerBuilder 12.6

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.