Home » Server Options » Streams & AQ » Exception 6502 on AQ
Exception 6502 on AQ [message #40581] Tue, 22 October 2002 08:56 Go to next message
Cora
Messages: 3
Registered: October 2002
Junior Member
Hi,

I'm using AQ and got the 6502 error by mapping the data. I have I table, here its declaration:
CREATE TABLE "REFERNEZ" (

"REFERENZNUMBER" NUMBER(12),
"MESSAGETYP" NUMBER(38),
"REFERENZ" VARCHAR2(12));

The Objectype for the Queue is the same:

CREATE OR REPLACE TYPE "REFERENZOBJ" AS OBJECT (
"REFERENZNUMBER" NUMBER(12),
"MESSAGETYP" NUMBER(38),
"REFERENZ" VARCHAR2(12));

For mapping data in Queuetable I'm using this procedure

CREATE OR REPLACE PROCEDURE "AQ_REFERENZ"
IS
v_MESSAGETYP NUMBER;
v_REFERENZ VARCHAR2(12);
v_REFERENZNUMBER NUMBER(12);

v_enqueue_options DBMS_AQ.enqueue_options_t;
v_message_properties DBMS_AQ.message_properties_t;
v_message_handle RAW(16);
v_message REFERENZOBJ;
BEGIN
/*
* Jeder Datensatz in der Tabelle tmp_ebdv_einbuchung
* wird nun mit "enqueue" in die ebdv_einbuchungQ geschrieben.
*/
FOR i IN ( SELECT MESSAGETYP
,REFERENZ
,REFERENZNUMMER
FROM DB2. REFERNEZ
)
LOOP
v_MESSAGETYP := I. MESSAGETYP;
v_REFERENZ := I.REFERENZ;
v_REFERENZNUMBER := I.REFERENZNUMBER;

v_message := konz_nacherhebungObj ( v_MESSAGETYP
,v_REFERENZ
,v_REFERENZNUMBER);

DBMS_AQ.ENQUEUE ( queue_name => 'db1.referenzQ',
enqueue_options => v_enqueue_options,
message_properties => v_message_properties,
payload => v_message,
msgid => v_message_handle
);
END LOOP;

END;

Queue is also applyed and ok. I use one database with the two schemas db1 and db2.
When the value of MESSAGETYP is '111112222233' everthings is ok, is its value '1111122222333'
I get numeric or value error: number precision too large. So whats going wrong?

regards
Cora
Re: Exception 6502 on AQ [message #40583 is a reply to message #40581] Tue, 22 October 2002 09:23 Go to previous messageGo to next message
ROC
Messages: 13
Registered: October 2002
Junior Member
Hi Cora,
Only a try, but are you sure you did not accidently mixed up messagetyp with referenznumber in konz_nacherhebungObj?
Cheers
roc
Re: Exception 6502 on AQ [message #40606 is a reply to message #40581] Wed, 23 October 2002 01:21 Go to previous messageGo to next message
Cora
Messages: 3
Registered: October 2002
Junior Member
Hi,
I checked it, they aren't mixed
Cora
Re: Exception 6502 on AQ [message #40609 is a reply to message #40606] Wed, 23 October 2002 05:15 Go to previous messageGo to next message
ROC
Messages: 13
Registered: October 2002
Junior Member
Sorry Cora,
I don't know other reasons. Hope you'll find a better help.
By the way, on one line of code, you are declaring v_messagetyp as number and not as number(38). Normally, this should not hurt but...
Good Luck
roc
Re: Exception 6502 on AQ [message #40612 is a reply to message #40606] Wed, 23 October 2002 05:37 Go to previous messageGo to next message
Rick Cale
Messages: 111
Registered: February 2002
Senior Member
First I know nothing of AQ but what I am seeing
is you have several NUMBER datatype declared as length 12 which happens to be same length of value that is working. The value that is not working is lenght of 13.
Try increasing size of your NUMBER datatypes or just declare as NUMBER. Purely an educated guess.

Rick
Re: Exception 6502 on AQ [message #126481 is a reply to message #40609] Tue, 05 July 2005 03:45 Go to previous message
d.dineshkumar
Messages: 211
Registered: April 2005
Location: Kolkatta
Senior Member
hi cora,
I am new to Advance Queuing,can u pls give me some idea,what is it.I am getting confused.What is the relation between it and dbms_job.
How should i interpret these.

Thanks
Dinesh
Previous Topic: help me, frank!!about stream capture
Next Topic: Streams on 30 Instances
Goto Forum:
  


Current Time: Thu Mar 28 09:30:38 CDT 2024