Posts Tagged ‘gotcha’

Beware of Comments in SQL

In SQL and PL/SQL there are two comment styles you can use, single-line and multi-line:

Multi-line comments begin with a slash and an asterisk (/*) and end with an asterisk and a slash (*/). the comment can span multiple lines. single-line comments begin with — (two hyphens) and end with a line break. The comment text cannot […]

NO_DATA_FOUND Gotcha

Lewis Cunningham’s “mini” tip about the NO_DATA_FOUND exception in PL/SQL is interesting. He shows how this exception is not always raised when you expect it to be raised. Here is another NO_DATA_FOUND gotcha you should be aware of:

LOBs Gotcha in ColdFusion

A few weeks ago I wrote a post about how to Save/Download files to/from Oracle using ColdFusion. The example I used in the post was about saving Excel files as a BLOB in an Oracle table.

Today, I ran across an issue with file sizes greater than 244 KB. I was testing with a 7 MB […]

SQL PLUS Gotcha

While reading the oracle-l mailing list, someone asked a question about (auto)commiting transactions in SQL Plus. Consider:

Flash CFFORM Gotcha

I had a problem with a flash CFFORM. It would not show up in Internet Explorer. However, Firefox had no problem displaying it. The flash form was part of an application using the Mach-II framework (which I’m converting now to Model-Glue). I had a general layout template in which I included the body of […]

ArrayDeleteAt Gotcha

Be careful when using ArrayDeleteAt. When an element is deleted, ColdFusion recalculates index positions. For example, in an array that contains the months of the year, deleting the element at position 5 removes the entry for May. After this, to delete the entry for June, you would delete the element at position 5 (not 6). […]