Home » Server Options » Streams & AQ » sqlca.sqlcode-1480
sqlca.sqlcode-1480 [message #159761] Tue, 21 February 2006 05:28 Go to next message
Messages: 30
Registered: November 2005


I am assigning string to a bind variable and also terminating the string with null terminator by using '\0'. I am using this string to enqueue messages.

When I enqueue single message it works fine but when I try to enqueue multiple messages using the same string I get the above mentioned error after last message has been sent. It does not matter how many messages are being sent it is always with the last messages that I get.

The method used for enqueuing message is "DBMS_AQ.ENQUEUE" and the language is proC.

Any idea how to get rid of this ??

Error is SQLCA.SQLCODE-1480

Thanks in adv.


[Updated on: Tue, 21 February 2006 05:30]

Report message to a moderator

Re: sqlca.sqlcode-1480 [message #164885 is a reply to message #159761] Mon, 27 March 2006 05:36 Go to previous message
Messages: 173
Registered: January 2006
Senior Member
Why don't you get the error message text printed too? That'll help identify your problem.

And you could post the relevant piece of code here.

Previous Topic: Using SQL statement to browse OJMS queue
Next Topic: Stream or advance replication for Multimaster environment
Goto Forum:

Current Time: Sat Mar 25 15:12:16 CDT 2023