Error while executing sql script!

Question

I am defining a variable in "userdata.sql",its contents are

SET DEFINE ON;
DEFINE name = Gaurav
DEFINE today =10/10/2011 --variable that contain date value.

==================================================================================

I am creating another file called xyz.sql

@userdata.sql
DECLARE 
v_date DATE;
v_name varchar2(10);
BEGIN
v_date:='&today';
v_name:='&name';
dbms_output.put_line('name is '||v_name);
dbms_output.put_line('date is '||v_date);
end;

On execution of xyz.sql its throwing an error ora-01840 input value not long enough for date format. Please suggest the solution to it. The RDBMS i am using is ORACLE

Tony Andrews · Accepted Answer · 2011-05-17 11:37:13Z

2

Change this line:

v_date:='&today';

to:

v_date:=to_date('&today','DD/MM/YYYY');

i.e. specify the date format (it could be 'MM/DD/YYYY' instead).

answered May 17, 2011 at 11:37

Tony Andrews

133k23 gold badges230 silver badges266 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Error while executing sql script!

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related