Different rows coming back. Identical SQL, no parameters/retrieval
arguments. Copy/past it from the DW painter or DB Administrator window into
SQLNavigator or TOAD and you'd get "the right stuff". PB was missing rows.
The nasty bit was that it wasn't missing the entire result set. So, a
casual observer might not notice it. We happened to be not so casual one
day when we entered some data and it wasn't coming back. :-)
I'm sorry I don't have more details. It's been probably a half year or
more, and we spent so much time determining that the problem was in the
Oracle 8 driver that as soon as we found our customer would accept delivery
using the O73 driver, we switched back and never looked back.
--dang
-----Original Message-----
From: Henrik Jakobsen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 23, 2000 02:26
To: '[EMAIL PROTECTED]'
Subject: RE: PFCSIG Powerbuilder & Oracle 8i
Hi Griffith!
Can you elaborate on the 'different result set' issue?
Is is different data, different columns or is it so different that there is
an error at runtime?
BR
/Henrik Jakobsen
-----Original Message-----
From: Griffith, Daniel M.
To: 'Holt, Brian'; '[EMAIL PROTECTED]'
Sent: 22-05-00 18:04
Subject: RE: PFCSIG Powerbuilder & Oracle 8i
We tried 6.5.1 with the 8i drivers and had bad results (e.g., a
different
result set coming back when you're in the DW painter vs runtime). We
also
had problems calling stored procedures. I don't recall the details at
this
time, but we used the O73 drivers to connect to Oracle 8, and life was
good
again.
--dang
-----Original Message-----
From: Holt, Brian [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 22, 2000 08:42
To: '[EMAIL PROTECTED]'
Subject: PFCSIG Powerbuilder & Oracle 8i
Hello all,
I currently use Powerbuilder Enterprise Version 6.5 and I am shortly
converting from an Oracle 7.3 Database to Oracle 8i (version 8.1.6)
Does anybody know where I can get the database drivers for 8i from. Also
has
anybody had any problems using Oracle 8i with 6.5 on
an NT environment.
Many Thanks
Brian Holt
EMAIL [EMAIL PROTECTED]
***********************************************************************
Confidentiality: This e-mail and its attachments are intended for the
above named recipient(s) only and may be confidential and/or
privileged. If they have come to you in error you must take no action
based on them, nor must you copy or disclose them or any part of their
contents to any person or organisation; please reply to this e-mail
and highlight the error immediately and delete this e-mail and its
attachments from your computer system.
Security Warning: Please note that this e-mail has been created in the
knowledge that Internet e-mail is not a 100% secure communications
medium. We advise that you understand and observe this lack of
security when e-mailing us.
Viruses: Although we have taken steps to ensure that this e-mail and
its attachments are free from any virus, we advise that in keeping
with good computing practice the recipient should ensure they are
actually virus free
***********************************************************************
> [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE
COMMANDS,
ADDRESS
> A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help
pfcsig
> SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
> [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE
COMMANDS, ADDRESS
> A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help
pfcsig
> SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
> [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS,
ADDRESS
> A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig
> SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
> [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS, ADDRESS
> A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig
> SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
