Home » Developer & Programmer » Forms » Oracle Blob Display Error
Oracle Blob Display Error [message #225838] Wed, 21 March 2007 13:02 Go to next message
loki_l77
Messages: 1
Registered: March 2007
Junior Member


Environment : Using Oracle Forms 6i (Currently on Patch 6.0.8.16) and Oracle 10g.
Problem : Error “Ora-00932 Inconsistent Data Types” when displaying a blob from a database table using Oracle 10g.

Problem Description : Currently in the existing application we have Oracle Forms 6i with Oracle Database version 8i.
There are no errors while displaying a blob (image) from the database table on my Oracle form.
Upgraded to Oracle 10g but with the existing version of Oracle Forms we cannot display the blob in the Forms.
If I remove the blob display from the form everything else on the form works fine.

Tried to update the Oracle Forms to version 6.0.8.16 using Patch 7 but it did not resolve the problem.

Tried to go through the bug fixes in the recent Forms version upgrade released by Oracle but did not see anything related to problem with blob display using Oracle 10g.

Did anyone else in the group faced the same problem?
What patch level resolved the problem?

Any ideas?

thanks and regards
Loki.

Report message to a moderator

Re: Oracle Blob Display Error [message #225912 is a reply to message #225838] Wed, 21 March 2007 22:48 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Please post the 'create table' script for the table as shown by the two database versions.

David

Report message to a moderator

Re: Oracle Blob Display Error [message #281469 is a reply to message #225838] Sat, 17 November 2007 03:14 Go to previous messageGo to next message
tarek456
Messages: 2
Registered: September 2006
Location: Lebanon
Junior Member
Environment : Using Oracle Forms 6i (Currently on Patch 6.0.8.16) and Oracle 10g.
Problem : Error “Ora-00932 Inconsistent Data Types” when displaying a blob from a database table using Oracle 10g.

am facing the same problem.
Plz cab anyone help.

Thanks a lot.
Best Regards.
Tarek.

Report message to a moderator

Re: Oracle Blob Display Error [message #281709 is a reply to message #225838] Mon, 19 November 2007 01:24 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
I suggest upgrading to the last patch of 6i which is 17 (or 19 I can never remember). If you are going to stick with an old version of Forms at least use the last patchset.

David

Report message to a moderator

Re: Oracle Blob Display Error [message #281846 is a reply to message #281709] Mon, 19 November 2007 08:52 Go to previous messageGo to next message
tarek456
Messages: 2
Registered: September 2006
Location: Lebanon
Junior Member
Hi, 10x a lot 4 ur reply,
but, plz, i need from u a link to download the latest version for oracle patch

Report message to a moderator

Re: Oracle Blob Display Error [message #281891 is a reply to message #281846] Mon, 19 November 2007 18:22 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Do NOT use IM speak. It is rude and not part of this site's acceptable practice.

All patches are available from metalink.

David

Report message to a moderator

Previous Topic: Vertical Scroll bar
Next Topic: Form6I flicker on Dialog Box - Switching Sessions
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Feb 02 21:50:49 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.