ORA-01461: can bind a LONG value only for insert into a LONG column

Disapprove with me!
Disapprove with me!

Okey, you know Oracle. A very good database, a very old database, a very solid rock. Not famous for its error messages. I have already stumbled upon a misleading error on the old rock.

This error anyway is incredible. If you try to push a very long text in a varchar2, you can end up with a

ORA-01461: can bind a LONG value only for insert into a LONG column

error.

Stack overflow promptly reported this years ago, so you can check it with your eyes.

 

 

Oracle Invalid number ORA-01722

I stumbled upon a very brain-f**k error on Oracle 10g on these days.

Context: the following query

SELECT
  * 
 FROM
  (    
    SELECT
      TO_NUMBER(CUSTOMER_ID) AS SNDG
    FROM
      BAD_CODES_TABLE    WHERE    
    AND I_LIKE=UPPER('STATIC_CONDITION')
    AND CUSTOMER_ID NOT LIKE '%P%'
  )
  S
WHERE
  TO_NUMBER(S.SNDG) >2000

could trigger a Invalid number if CUSTOMER_ID column contains invalid numbers.

Why?

Well…if you ask to “explain plan”, you will get something like

  • a table full scan
    • Filter Predicates AND
      • I_LIKE=UPPER(‘STATIC_CONDITION’)
      • TO_NUMBER(S.SNDG) >2000
      • CUSTOMER_ID NOT LIKE ‘%P%’

Continue reading “Oracle Invalid number ORA-01722”

Linkedin privacy simpatia

Dovete stare molto attenti alla vostra Privacy. Mi hanno fato notare che LinkedIn ha silenziosamente attivato un checkbox che consente di usare la vostra foto per…farsi pubblicità!

Per disattivarlo, andate sulle impostazioni, cliccate su Account poi su “Gestisci Social Advertising” e poi deselezionate il box più sotto!

Lega per l’abolizione di Maven

Da Wikipedia leggiamo

maven (also mavin) is a trusted expert in a particular field, who seeks to pass knowledge on to others. The word maven comes from the Hebrew, viaYiddish, and means one who understands, based on an accumulation of knowledge

 

Ora il professor Pippero ha stilato la seguente top ten delle frusrazioni

[table id=3 /]

 

Maven fa male. Fidatevi, io ho usato anche Maven 1.0. So come era. So che non è cambiato. So che è peggio del vostro peggiore incubo.

Potete smettere.

Fatelo per me!…se proprio non potete, leggetevi questo per passare il tempo.

Automatically refresh your user’s Session behind the scenes using jQuery and Asp.Net

Sometimes, a client-based refresh of the session is the only viable option.

Anyway, we must define this a “bad idea”, because you can end up stuffing even more problems on your architecture…

Now this is something that may or may not be useful to a lot of people, depending on you situation, you may want the user to elect to refresh their Session or not (like banks usually do); but this is for applications that may have a lot of idle time and users are annoyed with their Sessions dying… considering most users don’t know what a Session is, but they know that the application stops working correctly.

It uses jQuery and is incredibly simple, just a few lines of code, and no screen flicker or any annoyance to the user at all; ignorance is bliss. First I include the following in the code-behind in any page you need to keep refreshed (works on masterpages as well)[…]

via Automatically refresh your user’s Session behind the scenes using jQuery and Asp.Net.