Home » SQL & PL/SQL » SQL & PL/SQL » multiple inline view in pl/sql?
multiple inline view in pl/sql? [message #36342] Sun, 18 November 2001 23:10 Go to next message
hanhonghee
Messages: 1
Registered: November 2001
Junior Member
is it possible to use multiple inline view in pl/sql
like this?

CREATE OR REPLACE procedure aaa
is
a char(8);
b char(8);
begin
select to_char(sysdate,'yyyymmdd'),
(select to_char(sysdate,'yyyymmdd') from dual)
into a,b
from dual;
end;
/

the sql state is valid... in sqlplus
but error occurs when I compile it

this code doesn't created with this error message
"PLS-00103.... ( - +
mod not null others <an identifier>
<a double-quoted delimited-identifier> <a bind variable> avg
count current exists max min prior sql std"

please tell how to use inline view in pl/sql block....
not in from clause. in field....

----------------------------------------------------------------------
Re: multiple inline view in pl/sql? [message #36352 is a reply to message #36342] Mon, 19 November 2001 11:06 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
you need to re-structure the statement and alias 
the second date.
CREATE OR REPLACE procedure aaa
 is
 a char(8);
 b char(8);
 begin
 select to_char(sysdate,'yyyymmdd'), x.date2 
  into a,b
  from dual, (select to_char(sysdate,'yyyymmdd') date2 from dual) x;
 end;


----------------------------------------------------------------------
Previous Topic: Any easy way to run PL/SQL?
Next Topic: procedures parameters
Goto Forum:
  


Current Time: Sun Sep 27 13:47:25 CDT 2020