Home » Developer & Programmer » Forms » Inconsistent datatype
Inconsistent datatype [message #211316] Wed, 27 December 2006 23:12 Go to next message
mhdsuhail
Messages: 6
Registered: December 2006
Junior Member
Hi
I hae an applicaiton developedin forms6i that was running fine on Oracle9i database. When the database was upgraded to Oracle10g release2, i have been facing problems with the CLOB datatatype that i was using in one of the forms. Insertion through the forms take place fine. But when I query for the same it gives me an error - inconsistent datatype. the same query works fine in SQLplus and reports 6i. WHat could be the problem? IS there any issues with regard to this problem?
Help would be appreciated.
Thanks in advance.

msl
Re: Inconsistent datatype [message #211328 is a reply to message #211316] Thu, 28 December 2006 00:16 Go to previous messageGo to next message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Did you check form item datatype?
Re: Inconsistent datatype [message #211336 is a reply to message #211328] Thu, 28 December 2006 00:44 Go to previous messageGo to next message
mhdsuhail
Messages: 6
Registered: December 2006
Junior Member
I was using char datatype with width given as 16000.
Later i tried giving datatype as LONG as well. still it gives me the same error. forms unable to query. inconsistent datatype.
Re: Inconsistent datatype [message #211341 is a reply to message #211336] Thu, 28 December 2006 01:19 Go to previous messageGo to next message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
LONG *should* be OK ... what was this item's length? Maximum allowed is 65,534 bytes (Developer 10g - I don't have 6i to check it, but you could: in item's property palette, go to the Datatype property and press F1; find what it says about the LONG datatype).
Re: Inconsistent datatype [message #211346 is a reply to message #211341] Thu, 28 December 2006 02:12 Go to previous messageGo to next message
mhdsuhail
Messages: 6
Registered: December 2006
Junior Member
Thanks.

I could have used LONG datatype( you mean on the form or Database).If in database But I also use the field as a part of the query. Then I think I will have to use work arounds for it right. And the length of some of the rows is more than 4000 bytes.

In forms I have tried using both LONG as well as CHAR as datatype. Both returns the same error message. Length was given as 16000.

Is there any issues with forms6i querying for CLOB data? Insertion works fine as I mentioned earlier. Or is there any database configuration to be done??
Thanks

[Updated on: Thu, 28 December 2006 02:13]

Report message to a moderator

Re: Inconsistent datatype [message #212187 is a reply to message #211346] Thu, 04 January 2007 04:02 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem?

David
Re: Inconsistent datatype [message #212199 is a reply to message #212187] Thu, 04 January 2007 04:17 Go to previous messageGo to next message
mhdsuhail
Messages: 6
Registered: December 2006
Junior Member
No, I havent solved my problem.

Thanx
Suhail
Re: Inconsistent datatype [message #212254 is a reply to message #212199] Thu, 04 January 2007 06:09 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you googled 'clob 10g'?

What is the error code that you are receiving from 10g?

David
Re: Inconsistent datatype [message #212260 is a reply to message #212254] Thu, 04 January 2007 06:26 Go to previous messageGo to next message
mhdsuhail
Messages: 6
Registered: December 2006
Junior Member
No ihavent googled clob 10g.

Oracle10g does not five me any error message. Rather it is Forms6i which give me the message unable to query. It gives the message inconsistent datatypes
Re: Inconsistent datatype [message #212345 is a reply to message #212260] Thu, 04 January 2007 17:44 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Okay. What is the error code that you are receiving from 6i?

David
Re: Inconsistent datatype [message #212809 is a reply to message #212345] Mon, 08 January 2007 07:50 Go to previous messageGo to next message
mhdsuhail
Messages: 6
Registered: December 2006
Junior Member
Problem solved after upgdating forms with patch17. Thanks to everyone who cooperated.
Re: Inconsistent datatype [message #237464 is a reply to message #211316] Mon, 14 May 2007 10:22 Go to previous message
lavallee_g
Messages: 22
Registered: May 2005
Location: Quebec
Junior Member
Hi, i'm currently testing an upgrade to 10g with form 6i. I had the same problem and I used a long 32767 and it was working well. Whats the max length of you data in your table?
Previous Topic: Forms Version
Next Topic: Problem to use Clob Field in Forms & Report
Goto Forum:
  


Current Time: Wed Dec 07 09:02:44 CST 2016

Total time taken to generate the page: 0.14323 seconds