A strange problem [message #39625] |
Sun, 28 July 2002 05:00 |
Pradeep
Messages: 55 Registered: July 2000
|
Member |
|
|
I am writing a simple pl/sql block which is somewhat like this,
DECLARE
lv_value VARCHAR2(20);
BEGIN
lv_value := TO_CHAR(800 * 4);
lv_value := TO_CHAR('3200');
lv_value := TO_CHAR(SYSDATE);
lv_value := TO_CHAR(NULL);
END;
then the line
lv_value := TO_CHAR('3200'); generates an error, while writing the same code in sql prompt
select TO_CHAR('3200') " output" from dual; executes fine.
please tell me why this is so?
|
|
|
|