Re: data does not exist :-(

On 11/6/06, Alain Roger <raf.news@gmail.com> wrote:
> Hi,
>
> Finally, i've come to the following solution for my stored procedure :
> -----------------------------------
> -- Function: "SP_U_001"("TypeOfArticle" "varchar")
>
> -- DROP FUNCTION "SP_U_001"("TypeOfArticle" "varchar");
>
> CREATE OR REPLACE FUNCTION "SP_U_001"("TypeOfArticle" "varchar")

> however, when i run it thanks --> select SP_U_001('action');

if you double quote a function (or anything else)'s name when you
create it, you must also double quote it when you call it:

select "SP_U_001"('action');

I would advise you to use lower case names for things to avoid having
to do this.

merlin