VC++: int keyword gives different results in Oracle 9i and 10g

35 pts.
Tags:
Integer variable
NUMBER datatype
Oracle 10g
Oracle 9i
Oracle development
Variables
VC++
Visual C++
Visual C++ 6.0
In my code i am using a structure with integer variable and this variable is used to accept values from generic VC++ 6.0 functions, the value which got filled to the variable is from a table field whose datatype is NUMBER(10), in oracle 10g it runs fine but in oracle 9i it always returns 0, any idea to resolve this problem.

Answer Wiki

Thanks. We'll let you know when a new response is added.

I am using VC++ 6.0 MFC classes, the function <b>GetFieldValue</b> sends the control to <b>case DBVT_DOUBLE:</b> in oracle 9i case while to <b>case DBVT_STRING:</b> in oracle 10g case.

The GetFieldValue function is in a static library which got called from a C file, yes both DBVT_DOUBLE and DBVT_STRING have results in the library but when the result is returned the value in oracle 9i is 0 while in 10g it is correct, but the thing i want to understand is why the function switches to different cases when database version changes.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    How are you retrieving the data from the database ? are you using OCI ?
    70,220 pointsBadges:
    report
  • carlosdl
    when you read m_dblVal (9i) and m_pstring (10g) the information is not there ?
    70,220 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following