Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to pass Interval data type variable in oracle stored procedure

IKApr 25 2020 — edited Apr 25 2020

Hi,i have a schedule table which contains sched_id number, arrival interval day(3) to second(2) columns
pastedImage_0.png
and have written a simple procedure

create or replace procedure schedule(p_start_time interval day to second) is

pastedImage_1.png

The procedure gives the error when i execute it, i don't know how to pass interval data type variable to procedure, please help.

This post has been answered by cormaco on Apr 25 2020
Jump to Answer
Comments
Post Details
Added on Apr 25 2020
3 comments
1,367 views