Watch, Follow, &
Connect with Us

QualityCentral

Public Report
Report From: Delphi-BCB/Database/DBExpress/TSQLStoredProc    [ Add a report in this area ]  
Report #:  61257   Status: Closed
Errors with Oracle 10g procedures
Project:  Delphi Build #:  C++Builder® 200
Version:    11.2 Submitted By:   Jouko Tahtinen
Report Type:  Crash / Data loss / Total failure Date Reported:  4/22/2008 1:19:48 AM
Severity:    Critical / Show Stopper Last Updated: 9/23/2008 4:10:25 PM
Platform:    All platforms Internal Tracking #:  
Resolution: Duplicate  Resolved in Build: : 12.0.3170.16989
Duplicate of:  64858
Voting and Rating
Overall Rating: No Ratings Yet
0.00 out of 5
Total Votes: None
Description
Errors with Oracle 10g procedures
Steps to Reproduce:
create or replace procedure test2(a in out number)
is
begin
a:= 12.111;
end;

---------------------------------------------
SQLStoredProc1->ParamByName('A')->AsFloat = 1.0;
SQLStoredProc1->ExecProc();

-> ERROR : TDBXTypes.FLOAT value cannot be accessed as TDBXTypes.FLOAT value type.

---------------------------------------------

SQLStoredProc1->ParamByName('A')->AsInteger = 1;
SQLStoredProc1->ExecProc();

-> ERROR : TDBXTypes.INT32 value cannot be accessed as TDBXTypes.INT32 value type.

---------------------------------------------

SQLStoredProc1->ParamByName('A')->AsString = 1.0;
SQLStoredProc1->ExecProc();

->ERROR : TDBXTypes.ZSTRING value cannot be accessed as TDBXTypes.ZSTRING value type.

---------------------------------------------

double value = 1.0;
SQLStoredProc1->ParamByName('A')->AsFMTBCD = VarToBcd( value);
SQLStoredProc1->ExecProc();

-> ERROR in VISTA and VISTA 64 : ORA-06502: PL/SQL:numeric or value error: character to number conversion error

works OK in windows 2000/XP

---------------------------------------------
Workarounds
NONE
Attachment
None
Comments

Eberson Pizzaia at 7/26/2008 6:13:42 AM -
i post more information in my report 64858 . is the same problem.
Eberson Pizzaia

Server Response from: ETNACODE01

Copyright© 1994 - 2013 Embarcadero Technologies, Inc. All rights reserved.