On 11/6/06, Alain Roger <raf.news@xxxxxxxxx> 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
