| Exception 6502 on AQ [message #40581] |
Tue, 22 October 2002 08:56  |
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  |
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 #40609 is a reply to message #40606] |
Wed, 23 October 2002 05:15 |
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 |
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 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
