Here's a sample of a stored procedure I've written:
Code: Select all
CREATE OR REPLACE FUNCTION "CarSystem"."InsertList"( ListName VARCHAR(50), ListTypeId INT, DomainId INT, Geofencing VARCHAR, Salt VARCHAR(50), WhiteListAlarmClassId INT ) RETURNS VOID AS $$
INSERT INTO "CarSystem"."Lists"
( "ListName", "ListTypeId", "DomainId", "LastUpdate", "Geofencing", "Salt", "WhiteListAlarmClassId" )
VALUES
( $1, $2, $3, NOW(), $4, $5, $6 );
$$ LANGUAGE SQL;
What am I doing wrong?
Thanks
Tony