| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Need help on SQL exception |
« View previous topic :: View next topic » |
| Author |
Message
|
| anilmekala |
 Posted: Tue Feb 03, 2015 4:28 am Post subject: Need help on SQL exception |
 |
|
Acolyte
Joined: 19 Oct 2012
Posts: 63
|
Hi,
I hope every body doing good.
As part my requirement i need to call one of external system stored procedure. I have written code as per ESQL specification.
I am getting below exception when i called that stored procedure.
[DataDirect][ODBC Shadow driver]The owner 'MVSB1_IMS_QA' was larger than SQL_MAX_OWNER_NAME_LEN from SQLGetInfo (
'MVSB1_IMS_QA' is my data source name.
Please help me on the exception or somebody has resolution steps please share it to me.
Thank you.
Regards,
Anil. |
|
| Back to top |
|
 |
| fjb_saper |
| Posted: Tue Feb 03, 2015 5:32 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Well Anil, seems to me the answer is quite clear and in the error message.
Obviously some value you have is bigger than the max allowed for its length...
You need to find out what that max length is and conform.... 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| anilmekala |
| Posted: Wed Feb 04, 2015 12:45 am Post subject: |
|
|
Acolyte
Joined: 19 Oct 2012
Posts: 63
|
Hi,
Thank your response.
I have decreased size of owner name . Now am getting different exception.
[DataDirect][ODBC Shadow driver][DATA]CATALOG MAP NOT FOUND.
Please help me how to resolve this.
Regards,
Anil. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Wed Feb 04, 2015 5:18 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| anilmekala wrote: |
Hi,
Thank your response.
I have decreased size of owner name . Now am getting different exception.
[DataDirect][ODBC Shadow driver][DATA]CATALOG MAP NOT FOUND.
Please help me how to resolve this.
Regards,
Anil. |
Talk to your DBA for that one...
_________________
MQ & Broker admin |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
