Recent content by mstanton

  1. M

    error when using INTERVAL in pl/sql

    Oracle=8.1.7.4 pl/sql developer=5.1.0.622 [This message has been edited by mstanton (edited 24 June 2003).]
  2. M

    error when using INTERVAL in pl/sql

    I am performing date / time manipulation in pl/sql. The following SQL runs fine. select sysdate - interval '60' minute from dual; the result = 6/24/2003 8:39:34 AM But when I put it in pl/sql I get the following error: create or replace function time_diff return date is v_result date...
Back
Top