Re: What is wrong with the following PL/SQL Block?
From: Valentin Minzatu <vminzatu_at_rogers.com>
Date: Sun, 28 Jul 2002 01:22:15 GMT
Message-ID: <bHH09.93184$WsS.12626_at_news01.bloor.is.net.cable.rogers.com>
Date: Sun, 28 Jul 2002 01:22:15 GMT
Message-ID: <bHH09.93184$WsS.12626_at_news01.bloor.is.net.cable.rogers.com>
The line
a:=SYSDATE+a; -- you try to assign a DATE value to a NUMBER;
"Andrew Wong" <andrew_at_i-cable.com> wrote in message
news:ahv77r$jbp1_at_rain.i-cable.com...
> What is wrong with the following PL/SQL Block?
>
>
> DECLARE
> a NUMBER;
> b VARCHAR2(30) DEFAULT 'My String';
> BEGIN
> a:=10;
> a:=SYSDATE+a;
> b:=b+' is not null';
> ...
> DBMS_OUTPUT.PUT_LINE(b);
> ...
> END;
>
>
Received on Sun Jul 28 2002 - 03:22:15 CEST