Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Stored Procedure Question
You cannot use simple select statement in PLSQL as in SQL*Plus.
Select ... into .. from <tablename> is the standard syntax in PLSQL.
HTH
Pradhan
Ian Steward wrote in message ...
>I am just starting to learn Oracle so be gentle. Here is my question:
>
>I am trying to create a stored procedure as follows:
>
>CREATE PROCEDURE SP_BOMINQ (ASSY CHAR ) AS
>BEGIN
>SELECT Assembly,Component,Usage,Revision,UOM,Datein,Dateout,ChangId,Line
>FROM BOM
>WHERE Assembly = ASSY
>Order By Line,Datein;
>END;
>
>This will not compile and gives me the following error:
>
>PLS-00428: an INTO clause is expected in this SELECT statement.
>
>I cannot see why I would need an INTO clause in a simple Select statement.
>Can someone advise?
>
>- Ian S.
>
>
Received on Thu Jul 22 1999 - 21:20:05 CDT