Strange behaviour in 9.4 while calling a stroed procedure remotely

Hi All, IHAC who is testing IDS Version 9.40 FC4 on HP-UX11.0 and are in the process of upgrading 7.31 to 9.40. Now while testing we encountered a unique situation in which we start getting error 674. (routine name cannot be resolved). When we tried to call a stored procedure remotely(from another instance on the same box) which accepts (char,int,int) as inputs and giving("0125",1,"2") as parameters in the stored procedure execute statement, it failed with the error 674 while the same thing works if we do it on the instance directly i.e., not remotely. I mean with same parameters ("0125",1,"2") But if we pass the parameters("0125",1,2) <see the difference now 2 is not in quotes> to the stored procedure while trying to execute it remotely, it works just fine. So is this a new feature or bug in 9.40 FC4. Has anybody had this kind of issue while testing the product. Your help is appreciated on this. __________________________________ Do you Yahoo!? Vote for the stars of Yahoo!'s next ad campaign! http://advision.webevents.yahoo.com/yahoo/votelifeengine/

I'm not positive on this one, but 9.40 stored procedures supports overloading. This gives you the ability to pass different parameters or data types and call different code with the same routine name. My guess is that your third parameter in the routine is not defined as a character and the engine is getting confused trying to find the routine with input parameters of (char, int, char) with the same name and it cannot. I know that in your scenario it only fails on remote calls. I would expect it to fail on local calls also. I've also had strange bugs revealed on remote calls that work fine on local instance calls. Are you passing the parameters the way they are defined in the routine? Does it also work sending ("0125",1,2) locally? Scott -----Original Message----- From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org]On Behalf Of Vineet Mehr.... Sent: Tuesday, July 20, 2004 12:05 PM To: ids@iiug.org Subject: Strange behaviour in 9.4 while calling a stroed procedure remotely [3265] Hi All, IHAC who is testing IDS Version 9.40 FC4 on HP-UX11.0 and are in the process of upgrading 7.31 to 9.40. Now while testing we encountered a unique situation in which we start getting error 674. (routine name cannot be resolved). When we tried to call a stored procedure remotely(from another instance on the same box) which accepts (char,int,int) as inputs and giving("0125",1,"2") as parameters in the stored procedure execute statement, it failed with the error 674 while the same thing works if we do it on the instance directly i.e., not remotely. I mean with same parameters ("0125",1,"2") But if we pass the parameters("0125",1,2) <see the difference now 2 is not in quotes> to the stored procedure while trying to execute it remotely, it works just fine. So is this a new feature or bug in 9.40 FC4. Has anybody had this kind of issue while testing the product. Your help is appreciated on this. __________________________________ Do you Yahoo!? Vote for the stars of Yahoo!'s next ad campaign! http://advision.webevents.yahoo.com/yahoo/votelifeengine/