SQL & PL/SQL

Hi Experts,

I am getting error when executing below PL/SQL block.

ora-00060 deadlock detected while waiting for resource

DECLARE

Schemaname          VARCHAR2(30);

mergequery          LONG;

BEGIN

FOR ownname IN (SELECT owner_name FROM schema_table WHERE sch_id !=0 ORDER BY owner_name)

LOOP

schemaname := ownname.owner_name;

mergequery := 'merge into SUS_CDS scs

        using( select make

                    , mjsc

                    , version

                    , ldate

                    , mtype

                 from '||schemaname||'.DOS_CHD ) src

         on ( scs.make   = src.make

          and scs.CLASS   = src.mjsc

          and scs.version = src.version )

        when matched then update

           set scs.ldate = src.ldate

             , scs.mtype = src.mtype';

EXECUTE IMMEDIATE mergequery;

COMMIT;

END LOOP;      

END;

Please help me.

Thanks.