REQUEST A DEMO

Tag: Oracle

SchemaEditor improvements when dropping columns on Oracle

July 8, 2013   I’ve been recently working with a couple of customers who were dropping database columns from their schema on Oracle, and the drops were taking a long time to complete. In one instance, the customer estimated it would take 50 hours to drop a bunch of columns from their contact table. In another, a customer observed that dropping two columns from table_site_part took over two hours. Dropping 3 columns from table_contact took over 1 hour. These long execution times can disrupt normal operations – especially those environments with limited maintenance windows. Dovetail’s schema editing tool (Schema Editor) and Amdocs schema editing tools (ddcomp, SchemaManager) all do the same basic operations when it comes to dropping columns. Basically they all do this: ALTER TABLE table_name DROP COLUMN column_name; There’s a better way. Set Unused On large tables the process of physically…

Clarify Infrastructure Upgrade Services for MS SQL and Oracle Customers

February 14, 2013 Are you running a Clarify version prior to Clarify 12.5? Is your Clarify database running on a version earlier than MS SQL Server 2005 or Oracle 10?   With the news that MS SQL 2000 will no longer be supported by Microsoft in March, we’ve been receiving a lot of inquiries this month about our Clarify Infrastructure Upgrade Services. While we haven't marketed it as a service in the past, our team has extensive experience upgrading RDBMS Infrastructures for Clarify clients.   It’s very common for organizations that have implemented Clarify over the last 20 years to lag behind on the Clarify version they are running and for good reason. Clarify upgrades are costly, time-consuming and the new features are often not the best fit for their business model. If you’re running an older version of Clarify and need to upgrade…

Calling Oracle Stored procedures using Powershell

May 15, 2012 I’ve been doing some Powershell work lately, and needed to call an Oracle stored procedure with input and output arguments. I didn’t see a good example that mimicked what I was doing, so once I figured it out, I figured it was a good idea to share it. Stored Procedure First, I created a simple stored procedure with both an input and output parameter.   Powershell script Then I created a Powershell script to call the stored proc. Overall, the logic of the script is pretty straightforward. Create an Oracle connection and an Oracle Command Set the Command type to be Stored Procedure Add an input parameter, and set its type and value Add an output parameter, and set its type Open the connection Execute the stored procedure Close the connection Read the value of the output parameter Output I…

Everyone play nice: BOLT, OLEDB, Oracle, 64-bit Windows

May 27, 2011 With 64-bit machines becoming more and more prevalent, we’ve seen some confusion popup around installing and using applications. Is the app 32-bit? 64-bit? which database provider do I use? Is my web app 32 or 64 bit? etc. It’s confusing. No doubt. tl; dr Short answer:  If you’re on a 64-bit machine, and using Oracle, use the 64-bit Oracle provider for OLE DB for BOLT. 64-bit Windows explained There’s a great post from last year that “explains 64 bit”: Programs are still in the same place, in %ProgramFiles%, unless you need the 32 bit version, which is in %ProgramFiles(x86)%, except on a 32 bit machine, where it’s still %ProgramFiles%. All those dll’s are still in %SystemRoot%System32, just now they’re 64 bit. The 32 bit ones, they’re in %SystemRoot%SysWOW64. You’re with me so far, right? Oh, and the 16 bit ones…

Support for Oracle 11

May 4, 2011 We have recently validated our product suite against Oracle 11. Due to our approaches to developing software, coupled with our use of .NET, all of our products worked as is. We didn’t have to change our apps to add support for Oracle 11. It was really just a testing exercise for us. Oracle 11 is now part of our continuous integration environment, so we know things work now, and will continue to work moving forward. Pretty sweet. This includes support for: Dovetail SDK Dovetail Mobile Dovetail Carrier Dovetail Seeker Dovetail SchemaEditor Dovetail Rulemanager Dovetail Agent Dovetail Admin Platform Guide Our online Platform Guide is the best place for the latest details on supported platforms. http://support.dovetailsoftware.com/selfservice/resources/platform-guide * One exception There is one exception for support of Oracle 11: ArchiveManager (DIET). We have some additional work to do there. If this is…

Calling SOAP web services from cbbatch on UNIX using an Oracle procedure

October 4, 2010 Yes, you read that right - calling SOAP web services from cbbatch on UNIX using an Oracle stored procedure. Even reading that kind of makes my head hurt. But, when you're between a rock and a hard place, sometimes you gotta do what you gotta do. I've been working with a customer recently who has created some web services using .NET and our Dovetail SDK. He needs to able to call these web services synchronously from ClearBasic code, both from the Clarify Classic Client (running on Windows) and from cbbatch (running on UNIX). Calling web services from the Clarify Classic Client Calling web services from the Clarify Classic Client is pretty straightforward. Since we're on Windows, we can use COM and ActiveX objects to do so. A few examples of this: Using the microsoft.XmlHttp object Using the Microsoft SOAP toolkit…

Some notes on using Oracle 11 Database Instant Client

September 16, 2009 I recently upgraded my day-to-day environment to Windows 7 (64-bit) using MSSQL 2008. This week I needed to do some Oracle work, so I needed to get DovetailAgent working with an Oracle 9 (technically 9.2.0.1.0) database, so I needed Oracle client software. The latest Oracle client version is 11, so I decided to give that a try. The actual Oracle database runs on a VM, so I just needed an Oracle client.   Here are a few notes about getting this working. Install Oracle Instant Client   Install the Oracle 11 Instant Client for your platform.   I installed mine into C:\oracle\product\11.1.0\client_1   I went to edit the tnsnames.ora file, and quickly realized that there wasn’t one. A little googling led me to a helpful blog post at DBAToolZ. Environment Variables   Following the instructions from that blog post, I created a new system environment…

Trailing wildcards fail to %MATCH% text at the end of the field on Oracle9i

December 4, 2007 Kevin ran into a weird Oracle issue this week in one of his tests.Setup: I have case id 275 with a case_history of "case is in queue SUPPORT" Query:select count(*) from table_case where id_number = '275' and case_history like %SUPPOR%'This query returns 1 row, as expected. Query:select count(*) from table_case where id_number = '275' and case_history like %SUPPORT%'This query returns 0 rows. I was expecting it to return 1 row.I don't understand why the 2nd query doesn't return the expected row.I would have expected that the percent character would have matched to zero or more characters.The problem happens on Oracle 9. Everything works as expected in Oracle 10.Can anyone explain this behavior? 

Trailing wildcards fail to %MATCH% text At the end of the field on Oracle9i

I have some software that generates SQL we support multiple versions of Microsoft SQL Server and Oracle. I ran into a failing test on Oracle today that was totally unexpected. [Test] public void Case_History_containing_a_queue_tag_should_be_destined_for_that_queue() { string queueName = "SUPPORT"; string caseHistory = String.Format("case is in queue {0}", queueName); string caseIDNumber = "275"; SetCaseHistoryForCase(caseIDNumber, caseHistory); string ruleText = String.Format(@"(case_history contains '{0}') -> ""{0}""", queueName); string[] queues = AutoDestRule.RunRule("case", ruleText, caseIDNumber); Assert.AreEqual(1, queues.Length); Assert.AreEqual(queueName, queues[0]); } The Gist There is a bit of noise in the test but the gist is that RunRule() generates and executes the following SQL: Here is what the database looks like for table_case: id_number case_history "275" "case is in queue SUPPORT" The test passes in Microsoft SQL Server but fails against Oracle. There is no difference in the SQL being generated between databases. I fired up Query…