mahesh_bk1
10-07-03, 13:57
| Hi Everybody, Can anybody help me with this problem. I am using oracle 8.1.7 version. I am trying to execute a PL/SQL block. I am getting the following error. Here i am sending the PL/SQL code and the error. declare a date; begin select (select sysdate from dual) into a from dual; end; / select (select sysdate from dual) * ERROR at line 5: ORA-06550: line 5, column 9: PLS-00103: Encountered the symbol "SELECT" when expecting one of the following: ( - + mod not null others <an identifier> <a double-quoted delimited-identifier> <a bind variable> avg count current exists max min prior sql stddev sum variance execute forall time timestamp interval date <a string literal with character set specification> <a number> <a single-quoted SQL string> ORA-06550: line 6, column 1: PLS-00103: Encountered the symbol "INTO" when expecting one of the following: ; return returning and or Thanks in advance Mahesh |