stored procedure double start

[al9349]

We have load balanced ColdFusion MX 6.1 environment .
From time to time while calling Oracle 9i strored procedures from cfm form the
double start of the called strored procedure happens within the interval of
less than 1ms.
Because this procedure tries to insert records into tables it causes PK
violations.
Any suggestions how to diagnose the double start would be appreciated.
I know that we can put some double start prevention measures into starored
proceure itself, but I'd like to diagnose the root cause of the promblem.

[MikerRoo]

Without more to go on, here's some general ideas:

1) Is the SP called somewhere inside a <CFMODULE> chain? If yes, does the
CFMODULE have an end tag like <CFMODULE ... ... ... />?
If so, remove the end tag, "/>" becomes ">".

2) It is possible that the load balancer is the source.

3) Any possibility that a user is double-clicking a submit button? (Happens
all the time.)

4) Check the CF and webserver and SQL logs to see what was running just before
the problem.

Of course, you already know that the SP needs to be rewritten... ALWAYS
check before insert and use transactions to keep threads/calls from stepping on
each other.

[CF_Oracle]

In addition to what MikerRoo said it would be recommended to add duplicates
checking before run stored procedure within the same transaction (that will
protect form PK violation even when user click twice and re-write procedure not
necessary). Also cfcatch for errror handling before transaction committed would
be good.