Re: hung Oracle PL/SQL process during "insert"

Alex Glaros wrote:

> Does anyone have any idea on what could be causing an insert statement
> to hang?
>
> There doesn't seem to be any tables dead-locking, and when I run a
> diagnostic tool to show me where in the SQL code it's hanging, it shows
> the following:
>
> INSERT INTO WLL_COPY_LICENSEE_LINKS_ERRORS
> (
> cle_css_copy_id,
> agency,
> license_type,
> license_number,
> cle_license_number,
>
>
> There are no records in the table above. Could it be waiting for a
> commit from another table? Any general ideas would be appreciated.
>
> Thanks,
>
> Alex Glaros

Three comments:

1. Does the table have any triggers?
2. What version of Oracle?
3. The SQL statement above is not complete. We need the entire statement to comment.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)