asked on
CREATE OR REPLACE PROCEDURE LCDS.PROC_GETPREVANDNEXT (
CURRIDNUMBER IN VARCHAR2,
ENDLOGMILE OUT NUMBER,
PREVIDNUMBER OUT VARCHAR2,
NEXTIDNUMBER OUT VARCHAR2
)
AS
BEGIN
select rs_end_log, prev_sect_id, next_sect_id
into endlogmile, previdnumber, nextidnumber
from vw_roadsections
where sect_id = curridnumber;
RETURN;
END;