Postgresql - Stored Procedure Help
Budget: $10 – $30 CAD
Hello I keep getting this error with my stored procedure - query has no destination for result data
Arguments (po1 in, required_date1 date, purchaser1 int, scope1 text, special_requirements1 booelan, rush1 boolean, project_id1 int, created_by_id int, notes text)
declare
workorder_name_string text;
Begin
select count(*) as project_workorders_count from roterranet.workorders where workorders.project_id = project_id1;
select workorder_id from roterranet.project where project.id = project_id1;
workorder_name_string := concat(workorder_id1,'-' ,project_workorders_count + 1);
insert into roterranet.workorders2
(workorder_name, po, required_date, purchaser, scope, special_requirements, rush, project_id, created_by_id)
values
(workorder_name_string, po1, required_date1, purchaser1, scope1, special_requirements1, rush1, project_id1, created_by_id1)
returning workorder_id as new_workorder_id;
return new_workorder_id;
end;
Arguments (po1 in, required_date1 date, purchaser1 int, scope1 text, special_requirements1 booelan, rush1 boolean, project_id1 int, created_by_id int, notes text)
declare
workorder_name_string text;
Begin
select count(*) as project_workorders_count from roterranet.workorders where workorders.project_id = project_id1;
select workorder_id from roterranet.project where project.id = project_id1;
workorder_name_string := concat(workorder_id1,'-' ,project_workorders_count + 1);
insert into roterranet.workorders2
(workorder_name, po, required_date, purchaser, scope, special_requirements, rush, project_id, created_by_id)
values
(workorder_name_string, po1, required_date1, purchaser1, scope1, special_requirements1, rush1, project_id1, created_by_id1)
returning workorder_id as new_workorder_id;
return new_workorder_id;
end;