Mira esto encontre que dice claramente que debes de usar la clausula INTO en el select... esta en ingles pero se entiende bien
Oracle plsql syntax stipulate that you cannot use plain "SELECT " clause directly, you have to use "SELECT INTO " clause.
so what you need to do is declare the variables to hold the columns from select clause first.
try this:
PROCEDURE SP_LIST_01 (i_Descripcion IN VARCHAR2)
IS
declare
l_cod_op varchar2(200);
l_des_tipo_op varchar2(200);
l_fec_adq varchar2(200);
BEGIN
SELECT OP.Cod_OP ,
TiOP.Des_Tipo_OP ,
OP.Fec_Adq into l_cod_op, l_des_tipo_op, l_fec_adq
FROM TBL_OP OP, TRF_TIPO_OP TiOP
WHERE OP.cod_tipo_op = TiOP.cod_tipo_op
ORDER BY OP.Des_OP ;
END SP_LIST_01;
Comment from ATAHAC
Date: 05/04/2004 09:25AM PDT
Comment
You must use SELECT INTO statement
You can find more information about it on :
http://download-west.oracle.com/docs...htm#sthref1857