LENGTH function
tomL got the error routine (length) ambiguous - more than one routine resolves to given signature when using LENGTH in a simple select. Claus Samuelsen asked for an example, IDS version and OS. rkusenet suggested querying sysprocedures for a user routine named LENGTH. Apsik guessed the argument's type was unclear and advised casting it explicitly. No confirmation of a fix.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
It would help a lot if you supply an example that gives you trouble. It's also a good to give information of IDS version and OS. LENGTH() is not just one function. Which function is executed depends on the parameter given. tomL wrote: > hello all, > > when i try to use LENGTH in a simple select statement, i receive the > error "routine (length) ambiguous - more than one routine resolves to > given signature". > there is no length procedure we have created and was of course > expecting informix to use its pre-defined stored proc. > can anyone tell me what is going on here and how i can fix it? > > thank you very much, > > tom
hello all, when i try to use LENGTH in a simple select statement, i receive the error "routine (length) ambiguous - more than one routine resolves to given signature". there is no length procedure we have created and was of course expecting informix to use its pre-defined stored proc. can anyone tell me what is going on here and how i can fix it? thank you very much, tom
what does the following sql return
select procid,procname from sysprocedures where upper(procname) = 'LENGTH' ;
"tomL" <tomcaml@yahoo.com> wrote in message news:3158a6a2.0407120805.6524a3c@posting.google.com...
> hello all,
>
> when i try to use LENGTH in a simple select statement, i receive the
> error "routine (length) ambiguous - more than one routine resolves to
> given signature".
> there is no length procedure we have created and was of course
> expecting informix to use its pre-defined stored proc.
> can anyone tell me what is going on here and how i can fix it?
>
> thank you very much,
>
> tom
Probably parameter of a length function you have constructed is an expression and type of that expression is not clear. Try to cast that parameter explicite. Uzytkownik "tomL" <tomcaml@yahoo.com> napisal w wiadomosci news:3158a6a2.0407120805.6524a3c@posting.google.com... > hello all, > > when i try to use LENGTH in a simple select statement, i receive the > error "routine (length) ambiguous - more than one routine resolves to > given signature". > there is no length procedure we have created and was of course > expecting informix to use its pre-defined stored proc. > can anyone tell me what is going on here and how i can fix it? > > thank you very much, > > tom