Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
ORA-01830: date format picture problem with a Procedure
Dave: It worked, thanks! Steve- Steveo99
- Post #6
- Forum: Oracle: All versions
-
ORA-01830: date format picture problem with a Procedure
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...- Steveo99
- Post #4
- Forum: Oracle: All versions
-
ORA-01830: date format picture problem with a Procedure
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...- Steveo99
- Thread
- Replies: 5
- Forum: Oracle: All versions
