这是我的程序,它编译得很好,当我输入电影标题时,我试图获得发行日期和发行时间:
create or replace PROCEDURE get_films
(fname IN film.title%type,
r_date OUT film.release_date%type,
dur OUT film.f_duration%type) AS
BEGIN
SELECT release_date, f_duration into
r_date, dur
FROM FILM
WHERE title = fname;
EXCEPTION
WHEN NO_DATA_FOUND THEN
r_date: