Home » SQL & PL/SQL » SQL & PL/SQL » How to correct ORA-01830: date format picture ends before converting entire input string error?
How to correct ORA-01830: date format picture ends before converting entire input string error? [message #253375] Mon, 23 July 2007 11:26 Go to next message
sharan_it
Messages: 140
Registered: July 2005
Location: Chennai
Senior Member
Am trying to call the procedure..

DECLARE
F_INT INTEGER;
F_DATE DATE;
p_ORBIT_NOS TABTYPNUM_9;
p_no_of_rows f_int%TYPE;
P_TIMESTAMP f_date%TYPE;
BEGIN
Vista_Apa_Scheduling.GET_ORDER_LIST_ORBIT_NOS(
NULL,
'UB',
'E',
'S',
'UNSOLD',
NULL,
NULL,
NULL,
NULL,
P_ORBIT_NOS,
p_no_of_rows,
p_timestamp);
END;

f_date is a type of date.and p_timestamp is of type f_date.
Here p_timestamp is a output parameter..and getting ORA-01830: date format picture ends before converting entire input string.
how to correct it..

Pls PL/SQl gurus help on this...
Re: How to correct ORA-01830: date format picture ends before converting entire input string error? [message #253376 is a reply to message #253375] Mon, 23 July 2007 11:41 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
Please read & FOLLOW posting guidelines in the STICKY post at top of this forum.
Re: How to correct ORA-01830: date format picture ends before converting entire input string error? [message #253379 is a reply to message #253375] Mon, 23 July 2007 12:04 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't use implicit conversion and this will go better.

Regards
Michel
Previous Topic: Calculate differences of previous values
Next Topic: I want function for FTP file to other server.
Goto Forum:
  


Current Time: Sun Dec 04 04:58:26 CST 2016

Total time taken to generate the page: 0.03869 seconds