Problem creating a simple procedure

[stebjo]

Why do i get a simple query like this invalid when i save it like
a procedure:
-----------------------------------------
CREATE PROCEDURE select_table
AS
BEGIN
select * from test where name = ('Kim');
END;
-------------------------------------------
When i get this procedure Valid:
-------------------------------------------
CREATE PROCEDURE insert_table
AS
BEGIN
insert into insert_table (name) values ('Kim');
END;

???????
using Oracle 8I

Please help!!

 

[Turkbear]

Look into REFCURSORS and IN and OUT parameters... Pl/Sql is not Sql or SqlPLus - It has specific requirements for returning data ( especially a whole row of data..)

hth


( ps the insert works because no data needs to be returned to the 'caller' - it is not well-formed however, and any errors would be undiscovered - read more about procedures in the Pl/Sql Docs..)

 

[stebjo]

Thank's man, at least i know what to look 4.
))