Welcome to Telelogic Product Support
  Home Downloads Knowledgebase Case Tracking Licensing Help Telelogic Passport
Telelogic DOORS (steve huntington)
Decrease font size
Increase font size
Topic Title: ORACLE DB access from DXL
Topic Summary:
Created On: 7-Aug-2006 09:04
Status: Post and Reply
Linear : Threading : Single : Branch
Search Topic Search Topic
Topic Tools Topic Tools
Quick Reply Quick Reply
Subscribe to this topic Subscribe to this topic
E-mail this topic to someone. E-mail this topic
Bookmark this topic Bookmark this topic
View similar topics View similar topics
View topic in raw text format. Print this topic.
Answer This question was answered by marc chetrit, on Monday, August 7, 2006 5:23 PM

Answer:
Hi Denis,

It's a great solution to my problem.

Thank you very much for your help.
 7-Aug-2006 09:04
User is offline View Users Profile Print this message


marc chetrit

Posts: 5
Joined: 4-Jan-2006

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.


Report this to a Moderator Report this to a Moderator
 7-Aug-2006 14:30
User is offline View Users Profile Print this message


Dennis Lockshine

Posts: 113
Joined: 7-Apr-2003

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
Report this to a Moderator Report this to a Moderator
 7-Aug-2006 17:23
User is offline View Users Profile Print this message


marc chetrit

Posts: 5
Joined: 4-Jan-2006

Answer Answer
Hi Denis,

It's a great solution to my problem.

Thank you very much for your help.
Report this to a Moderator Report this to a Moderator
Statistics
20925 users are registered to the Telelogic DOORS forum.
There are currently 1 users logged in.
The most users ever online was 15 on 15-Jan-2009 at 16:36.
There are currently 0 guests browsing this forum, which makes a total of 1 users using this forum.
You have posted 0 messages to this forum. 0 overall.

FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.