ORA-03113 while exec DBMS_AQADM.CREATE_QUEUE_TABLE

From: Vadim Grepan <_RMV_IT_kezal_at_mail.ru>
Date: Tue, 20 Jan 2004 16:39:03 +0300
Message-ID: <bujb12$fl9$1@n6.co.ru>

Hello All!

   There is problem with creating queue tables, Oracle 9.2.0.4 (Win32)    Is anybode overcome this very painful error? Metalink doesn't keep any    useful info :(

   Alert.log doesn't keep anything useful..

• cut === CREATE TYPE TMP_MESSAGE_T AS OBJECT (OPERATION VARCHAR2(1), TEXT VARCHAR2(2000));
  /
  

	BEGIN
	 DBMS_AQADM.CREATE_QUEUE_TABLE(
	 QUEUE_TABLE => 'QT_1',
	 MULTIPLE_CONSUMERS => TRUE,
	 AUTO_COMMIT => TRUE,
	 QUEUE_PAYLOAD_TYPE => 'TMP_MESSAGE_T');
	END;


	/


	ERROR at line 1:
	ORA-03113: end-of-file on communication channel

=== cut ===

Rgds, Vadim

--
Moscow, Russia

Received on Tue Jan 20 2004 - 07:39:03 CST