![]() |
Telelogic DOORS (steve huntington) | ![]() |
new topic :
profile :
search :
help :
dashboard :
calendar :
home
|
||
Latest News:
|
|
Topic Title: ORACLE DB access from DXL Topic Summary: Created On: 7-Aug-2006 09:04 Status: Post and Reply |
Linear : Threading : Single : Branch |
![]() |
![]()
|
![]() Answer: Hi Denis, It's a great solution to my problem. Thank you very much for your help. | |
![]() |
|
Hi All,
Using a piece of script found in this forum, I tried to connect to an external database from a dxl script. I connect to an ORACLE DB and it works fine except when retrieving values declared as NUMBER(6,0) in ORACLE (see "type_count" item in attached code) . For these values, DXL does not seem to convert correctly the value to integer. I always get a 0 value. I tried a similar script in VB and integer values are OK. I would be interested if someone already found a solution to this problem. I got same results using DOORS 7.1 or 8.1. Thanks in advance. |
|
![]() |
|
![]() |
|
Marc,
I did some development of ODBC connections and found that there were other types incorrectly returned into DOORS. To get around this, I found the "GetString" method and use it to return the entire row of the cursor, then I parse it to get the individual fields. I've attached the function I use for this purpose. It accepts a Buffer and the OLE Recordset, and returns the next available row into the Buffer. Hope this helps. -Dennis |
|
![]() |
|
![]() |
|
Hi Denis,
It's a great solution to my problem. Thank you very much for your help. |
|
![]() |
Telelogic DOORS
» DXL Exchange
»
ORACLE DB access from DXL
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.