LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Server (https://www.linuxquestions.org/questions/linux-server-73/)
-   -   The oracle error pls-00103 (https://www.linuxquestions.org/questions/linux-server-73/the-oracle-error-pls-00103-a-643979/)

wanghao 05-22-2008 04:19 AM

The oracle error pls-00103
 
PLS-00103: PLS-00103: Encountered the symbol "begin" when expecting one of
the following:
:=( not null range
default character
symbol ";" was substitued by "begin" to continue.

I got the error when create a procedure,as following:
create or replace procedure test_pl as
tempdate net_grid.device_name%type
begin
select device_name
info tempdate
where netmask='255.255.255.0';
dbms_output.put_line(to_char(tempdate));
end;


Any friend who knows it do help you ,all you best!

chrism01 05-22-2008 08:03 PM

Well, the syntax checker can be a bit off; I notice that

'info' should be 'into'

wanghao 05-23-2008 04:44 AM

yes,thanks.i make such a mistake ,but as i changed the problem still and have the same error!


All times are GMT -5. The time now is 05:49 AM.