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

Hello,

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.

Regards,
Sanjeev.

[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
hobbes
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.

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


Current Time: Fri Mar 29 04:59:02 CDT 2024