database job hangs

my db job hangs when ruinning remotely - i can;t see any errors, here is the trace file :

/*---------------------------------------------------*/
/* 7/8/02 18:55 */
/*---------------------------------------------------*/
(6a51288): LOGIN: (234 MilliSeconds)
(6a51288): CONNECT TO TRACE O84:
(6a51288): LOGID=devi
(6a51288): SERVER=inpro_leeds (0 MilliSeconds)
(6a51288): SELECT * FROM SYS.SESSION_ROLES WHERE ROLE = 'DBA' (0 MilliSeconds)
(6a51288): PREPARE: (0 MilliSeconds)
(6a51288): EXECUTE:
(6a51288): EXECUTE compaq_comm

And I have to stop the remote agent to get out of it.
But if I run teh command in SQL*PLUS:
execute compaq_comm;
It takes 7 seconds !!!!!
I don't understand why it is hanging like this.

SQL*Plus does not use Oracle OCI, all other 3rd party programs connecting to Oracle, including 24x7, do use it. Please check that your Oracle required support files are up-to-date.

Just out of curiosity try changing the command from EXECUTE to
BEGIN compaq_comm; END;

This will force Oracle to use PL/SQL engine instead of SQL engine.

: my db job hangs when ruinning remotely - i can;t see any errors, here is the
: trace file : /*---------------------------------------------------*/
: /* 7/8/02 18:55 */
: /*---------------------------------------------------*/
: (6a51288): LOGIN: (234 MilliSeconds)
: (6a51288): CONNECT TO TRACE O84: (6a51288): LOGID=devi
: (6a51288): SERVER=inpro_leeds (0 MilliSeconds)
: (6a51288): SELECT * FROM SYS.SESSION_ROLES WHERE ROLE = 'DBA' (0
: MilliSeconds)
: (6a51288): PREPARE: (0 MilliSeconds)
: (6a51288): EXECUTE: (6a51288): EXECUTE compaq_comm

: And I have to stop the remote agent to get out of it.
: But if I run teh command in SQL*PLUS: execute compaq_comm;
: It takes 7 seconds !!!!!
: I don't understand why it is hanging like this.

: SQL*Plus does not use Oracle OCI, all other 3rd party programs connecting to
: Oracle, including 24x7, do use it. Please check that your Oracle required
: support files are up-to-date.

: Just out of curiosity try changing the command from EXECUTE to
: BEGIN compaq_comm; END;

: This will force Oracle to use PL/SQL engine instead of SQL engine.
I changed it to BEGIN compaq_comm; END; and it worked and took a few seconds - I will check it tomorrow to see if it worked OK - this may have fixed the problem.
So what do you think was the problem ?