Delphi32.com - Home!
| Home/News | Downloads | Forums | D32 Magazine | Resources | Info and Facts |  
 
 Non-blob column in table required to perform operation with Oracle


Why am I getting the error "Non-blob column in table required to perform operation" when trying to access a BLOB or CLOB with Oracle 8?   

    TTables and Live TQueries may not allow access to Oracle 8 CLOB or BLOB fields when the user has a role of DBA, EXP_FULL_DATABASE, IMP_FULL_DATABASE or SELECT_CATALOG_ROLE especially if the table was created by a user without one of these roles. Users with these roles return LOB indexes in the list of index definitions because the BDE queries a different set of system views compared to users without these roles. These LOB indexes do not have corresponding column definitions. The error will occur when the primary key has a name that causes it to be sorted after the LOB indexes in the result set. The error does not occur for users with roles other than DBA, EXP_FULL_DATABASE, IMP_FULL_DATABASE or SELECT_CATALOG_ROLE. To determine what roles a the current user has query SYS.USER_ROLE_PRIVS. To determine what roles all users have been granted query SYS.DBA_ROLE_PRIVS when logged in as a user with a GRANTED role of DBA, EXP_FULL_DATABASE, IMP_FULL_DATABASE or SELECT_CATALOG_ROLE.  



  << Previous Faq     Complete List     Next Faq >>  



 
 Hits/month  2,500,000+ 
 Downloads
 (Since May 2000)
 7,393,709 
 Total Files  6,023 
 Forum msgs  7,670 
 Articles/FAQs  70+/900+ 
Kylix
Tips n Tricks
FAQs
Knowledge Base
Bug Listings
Articles
Books
Newsgroups
Links
Submissions
Testimonials
Advertising
Contact Us
About Us
Search Amazon:
Top Selling Software at Amazon

| Home/News | Downloads | Forums | Resources | Info and Facts | Testimonials |
  Site Search:
 


Comments/Problems: Webmaster@delphi32.com
Copyright © 1998-2006, Delphi32.com. All rights reserved.
Terms of Use