| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Procedure or Function Error |
« View previous topic :: View next topic » |
| Author |
Message
|
| yogi |
 Posted: Tue Jan 25, 2011 5:14 am Post subject: Procedure or Function Error |
 |
|
Apprentice
Joined: 13 Dec 2010
Posts: 35
Location: Pune, India
|
Hi,
I have called one function but its showing error for the below one . I tried wit the references also.
CALL cDatabaseRead ('SELECT countries_key, name
FROM countries
ORDER BY countries_key',
False, 'EAI:000013', DB_IN_PARAMS, DB_OUT_PARAMS, 'COUNTRIES');
ERROR : Incorrect function or procedure name "cDatabaseRead" or argument count.
_________________
YoGi |
|
| Back to top |
|
 |
| Vitor |
| Posted: Tue Jan 25, 2011 5:21 am Post subject: Re: Procedure or Function Error |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| yogi wrote: |
| ERROR : Incorrect function or procedure name "cDatabaseRead" or argument count. |
So that procedure is in scope for where you've called it from, has that number of parameters and all the types match?
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Tue Jan 25, 2011 5:22 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
You seem to be usingthe IBM software Services Asset library.
In that case, you need to include the following at the top of your ESQL file.
| Code: |
PATH LIB_Core; -- This allows use of the Asset core db procedures
|
Then you need to reference the project that has the code in it. In one place this was in LIB_CORE.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| yogi |
| Posted: Wed Jan 26, 2011 9:24 pm Post subject: Greetings...!!! |
|
|
Apprentice
Joined: 13 Dec 2010
Posts: 35
Location: Pune, India
|
PATH LIB_Core; -- This allows use of the Asset core db procedures
thank you davies the solution has worked out.........!!! 
_________________
YoGi |
|
| 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
|
|
|
|
