HereIsTheAnswer:
RENTAL# NUMBER
CUSTNAME VARCHAR2(15)
ITEM_NUMBER NUMBER(4)
OUT_DATE DATE
DUE_DATE DATE
IN_DATE DATE
FEE NUMBER(6,2)
sem: I tried the proc below with and without the session altered, without luck:
create or replace procedure AddRental (
p_custname IN rental.custname%TYPE...
Hello:
I've 1st set the following session level variable:
ALTER SESSION SET NLS_DATE_FORMAT = 'MM/DD/YYYY hh24:mi';
After this I wrote and sucessfully compiled this procedure:
create or replace procedure AddRental (
p_custname IN rental.custname%TYPE,
p_item_number IN...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.