Problème de génération de procédure
Bonjour tout le monde,
J'ai une procédure que j'ai créée mais qui me sort des erreurs alors que tout me parait être simple et correct !
Si quelqu'un peu me donner plus de détails ce serait cool ! :lol:
Voici le code :
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
|
CREATE OR REPLACE FUNCTION get_magasin(character varying, character varying)
RETURNS character varying AS
$BODY$
DECLARE
num_appelant ALIAS FOR $1;
num_appele ALIAS FOR $2;
res RECORD;
SEPC char(1);
BEGIN
SEPC := ';'; --- Separateur champs
SELECT INTO res * FROM cookie WHERE num_appelant = appelant AND num_appele = appele;
IF res.num_appelant IS NOT NULL
THEN
RETURN res.num_appele||SEPC||res.id_magasin||SEPC||res.date_appel;
ELSE
RETURN 'KO';
END IF;
END;
$BODY$
LANGUAGE plpgsql STABLE;
ALTER FUNCTION get_magasin(character varying, character varying) OWNER TO johnlobs; |
Les erreurs sont les suivantes :
Citation:
psql:create_fonction_get_magasin.sql:5: ERROR: unterminated dollar-quoted string at or near "$BODY$
DECLARE
num_appelant ALIAS FOR $1;" at character 107
psql:create_fonction_get_magasin.sql:6: ERROR: syntax error at or near "num_appele" at character 1
psql:create_fonction_get_magasin.sql:7: ERROR: syntax error at or near "res" at character 1
psql:create_fonction_get_magasin.sql:8: ERROR: syntax error at or near "SEPC" at character 1
psql:create_fonction_get_magasin.sql:10: ERROR: syntax error at or near "SEPC" at character 7
psql:create_fonction_get_magasin.sql:11: ERROR: syntax error at or near "INTO" at character 8
psql:create_fonction_get_magasin.sql:15: ERROR: syntax error at or near "IF" at character 1
psql:create_fonction_get_magasin.sql:17: ERROR: syntax error at or near "ELSE" at character 1
psql:create_fonction_get_magasin.sql:18: ERROR: syntax error at or near "IF" at character 5
psql:create_fonction_get_magasin.sql:19: WARNING: there is no transaction in progress
COMMIT
psql:create_fonction_get_magasin.sql:21: ERROR: unterminated dollar-quoted string at or near "$BODY$
LANGUAGE plpgsql STABLE;" at character 1
ALTER FUNCTION
Merci d'avance pour votre éventuelle aide !
