The Archives
-
07.24.06ColdFusion and Oracle inserting PL/SQL Block and Error PLS-00103: Encountered the symbolIf you want to insert a PL/SQL block using the <cfquery> tag you might see that your trigger, package, etc. is being saved in the Oracle database but it throws an error while executing, but Inserting the same PL/SQL statement within Oracle works just fine. Now before you go and rewrite your whole SQL statement within the <cfquery> many times there is luckily an easy answer to this challenge; With ColdFusion you can not issue a SQL statement within the <cfquery> tag which uses a ";". So what to do? Read on to see how to overcome this challenge.
-
07.13.06Date handling and limit records found in OracleI get a lot of questions on how Oracle handles dates and how to limit the found records in a select. So let us jump right in to the topic.Limiting recordsMost people coming from another SQL database ask me how to limit the records in a select. With MySQL it s a simple "limit 10" and your select returns only 10 records. With Oracle it is sort of the same but you get more power with your limitation.So for only returning 10 records we would create a select like: select * from yourtablewhere rownumber < 11This will return exactly 10 ...
-
06.12.06Free Oracle Database now available for more Linux DistrosOracle released their free Oracle XE database for Ubuntu, Mandriva and Demian Linux Distros. I am always amazed how Oracle pushes the Linux platform. Actually this is quite cool. You can get your free copy of the Oracle Database right here.
-
05.13.06Lucasfilm and OracleI haven't had time to post something lately, because we are busy finishing up our Enterprise Digital Asset Management which is available free of charge soon. More on this later. But.... I just read in the latest Oracle Magazine a story about Lucasfilm and how they use the Oracle database. Now these figures are quite impressive ....
-
04.18.06Larry Ellison on Open Source and maybe buying NovellI just read an interview with Larry Ellison, the CEO of Oracle. It is quite interessting how he talks about Open Source and Open Source companies in general. He even mentions that it might be possible for Oracle to buy Novell and sell it's own OS. Well, the battle against Microsoft continues.... The full interview can be read at ft.com (subscription needed to read part two).
-
04.11.06Oracle Error and how to fix it (ORA-01033)Recently while I was starting up my local copy of the Oracle database trough the service panel (Windows XP) I saw that I got some error message. Well, I thought that this was not an issue. Sure enough I got hit by a ugly error message when connecting to my web application that Oracle was not up and running. So, after some time trying to figure out I found the solution.
-
03.14.06Oracle releases SQL Developer (formerly Raptor)Oracle released the production version of SQL Developer (formerly known as Raptor). As from their website it states: "Oracle SQL Developer is a new, free graphical tool that enhances productivity and simplifies database development tasks. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own." We have been using SQL Developer in the last couple of betas and we think it is a way killer application. Also we all have now a cross platform ...
-
02.27.06Oracle’s Free Database available nowOracle released the final version of it's free Express Edition today. There is the limitation of a 4GB database, 1 GB of Ram and one CPU, but if you can live with this then go ahead and download it at http://www.oracle.com/technology/products/database/xe/index.html.
-
02.16.06Part one: Storing images in Oracle with ColdFusionThis is the first part of a "how-to" of storing images with Oracle's Intermedia feature from ColdFusion. To start of we already explained in an earlier post that Oracle has a feature called "Intermedia" which allows for advanced image manipulation trough PL/SQL. Thus with Intermedia we can manipulate images directly within the database without retrieving them first. Also, we can stream images to ColdFusion directly from Oracle without downloading them first. Ok, so off we go with an explanation of how to store images in the database.
-
02.11.06HTML DB becomes Oracle Application ExpressHTML DB is a exellent tool for administrating Oracle Databases. Since Version 2.0 it is a really serious tool for even developing applications. Once you have seen how easy it is to generate a database per copy and paste some lines, let's say from an Excel spreadsheet, you start to slowly figure what a useful tool it is. Now, Oracle decided to rename it to "Oracle Application Express" which acutally quite suits what it really does. Since it is free just go ahead and grab a copy and install it now. Great tool and the price is right. And just in ...
-
02.10.06Part two: How to increase the performance with ColdFusion and OracleIn the first part of this post we discussed how one can increase the performance of ColdFusion and Oracle by tuning the Software and coding in a way that we don't create an extra overhead. In this part we will look at the System level. Right now we will show some tweaks for Window Server 2003. Both Coldfusion and Oracle will benefit from these settings. Thing to know upfront For the start we should know that by default Windows Server 2003 is configured to be a Print and Filesharing Server. Thus the file cache has a higher priority then the kernel ...
-
02.08.06Part one: How to increase the performance with ColdFusion and OracleOne of the most asked questions around the world is how to increase the performance of ColdFusion and Oracle. Here are some hints from our daily work. Always use <cfqueryparam> when quering the database. This has shown an immense overall increase in performance. If you use <cfqueryparam> then ColdFusion does not need to "find out" what you want to pass on to the SQL statement, because we are telling what the datatype is for the SQL statement. We have also read that Caching of the SQL statement with <cachedwithin> parameter should increase the SQL statements as well. The problem that we have ...
-
02.07.06The better alternative then BLOB - meet IntermediaMany people think of storing images in a database as a complete overhead or even that the performance suffers. This might be very true for a database product that has no special image functions or performance issues with large objects stored within the database. Good news for every developer, meet Intermedia a part of Oracles Database offering..... Oracle Intermedia Intermedia is part of every Oracle Database (except Oracle's Express Edition. Well, they had to make you go for your money...) and is the most overlooked part within Oracle. With Intermedia you can replace all you blob fields with a intermedia type (ordimage). ...
-
02.07.06Oracle Rolls Out New Multicore Pricing and Licensing PolicyOracle published its new Pricing for Multi Core Processors. This is a must read for any Oracle Customer. Please be aware that you only need a Oracle Standard Edition One to have Razuna working. Here is the direct link to the new prices: http://www.oracle.com/corporate/press/2005_dec/multicoreupdate_dec2005.html
-
02.03.06The advantages of storing Assets within a databaseThe problem with File Systems and Digital Assets File system based media specialty servers continue to be in use in managing media such as digital images. The use of file systems to manage digital media such as images and video has led to specialty servers for different kinds of data. This results in data isolation and high systems admin and management costs. It also leads to scalability problems, high training costs, and complex support problems. File systems with their limited name space and indexing mechanisms notoriously perform poorly under high load. They are also not noted for running with high availability. They ...
recent posts
- Crew and Camera Man visible in 24 redemption
- Ask that DAM question
- Time Machine disables Bluetooth
- What the Open Source Barometer tells us
- I got myself some Art
- Apple forgot the - disable Trackpad settings - for the new MacBooks and a workaround
- Raise your voice and influence what will be in the next version of Razuna
Polls
Loading ...Social Media
