BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: No events within the next 45 days.

Oracle 12c support to BO varchar (4.2 SP3)


 
Search this topic... | Search Semantic Layer / Universe Designer... | Search Box
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Author Message
singh
Principal Member
Principal Member



Joined: 26 Sep 2005

Posts: 101
Location: CA, USA


flag
PostPosted: Mon Sep 17, 2018 10:27 am 
Post subject: Oracle 12c support to BO varchar (4.2 SP3)

Hi,
I are on BO version 4.2 sp3 and Oracle 11g.
Moving to 12c, and my question was if varchar objects in 12 c are supported by BO as in 11g, what I mean is, we have clob data fields in oracle 11g but when we upgrade to 12c, the data (4000+ bytes) in those fields should be equivalent to 12c varchar and not a clob is required any more.

So does BO support 12c varchar IDT/UDT universe objects as well as to be used in report level query filters?

Please let me know your thoughts
Thank you so much

_________________
where there is a will, there is a way
Back to top
erik.stenson
Forum Enthusiast
Forum Enthusiast



Joined: 30 Jul 2012

Posts: 1302


flag
PostPosted: Wed Sep 19, 2018 8:10 pm 
Post subject: Re: Oracle 12c support to BO varchar (4.2 SP3)

I think that this depends on the driver being used for the connection - not BO itself.
Back to top
joepeters
Forum Fanatic
Forum Fanatic



Joined: 29 Aug 2002

Posts: 6417
Location: Connecticut, USA


flag
PostPosted: Thu Sep 20, 2018 7:09 am 
Post subject: Re: Oracle 12c support to BO varchar (4.2 SP3)

This is purely a guess, since I haven't actually worked with the extended data types in 12c, but I would not expect there to be a problem. BO just sees a "string", so the database's maximum length should not matter.

Also, keep in mind that varchar2 in 12c is not a pure replacement for clob. It is limited to 32,767 characters, and it has to be enabled on the database instance.
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0307 seconds using 17 queries. (SQL 0.0031 Parse 0.0009 Other 0.0267)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo