Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Sybase > Error from sp_g...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 5 Topic 2433 of 2512
Post > Topic >>

Error from sp_getmessage

by "Kjellemann" <kjell@[EMAIL PROTECTED] > Mar 27, 2008 at 10:30 PM

I get an error when using sp_getmessage on a message that were put into 
sysusermessages with sp_addmessage.
The sql is like this:

 create proc kpTest as
declare @[EMAIL PROTECTED]
 varchar(255)
exec sp_getmessage 30003, @[EMAIL PROTECTED]
 output:

1> kpTest
2> go
Msg 11060, Level 16, State 1:
Server 'PADDATEST', Procedure 'sp_getmessage', Line 100:
This statement has exceeded the maximum number of recompilations (10).
This
indicates an internal error. Please note the error prior to this one and 
contact
Sybase Technical Sup****t.
(return status = -6)

Any solutions?
Version:
 Adaptive Server Enterprise/12.5.1/EBF 11420/P/Sun_svr4/OS 
5.8/ase1251/1823/32-b


Kjell P.
 




 5 Posts in Topic:
Error from sp_getmessage
"Kjellemann" &l  2008-03-27 22:30:00 
Re: Error from sp_getmessage
Manish Negandhi <negan  2008-04-08 02:40:09 
Re: Error from sp_getmessage
"Kjellemann" &l  2008-04-09 11:48:30 
Re: Error from sp_getmessage
Manish Negandhi <negan  2008-04-09 04:08:34 
Re: Error from sp_getmessage
"Kjellemann" &l  2008-04-11 13:59:45 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Thu Jul 24 1:30:16 CDT 2008.