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