PL/SQL Procedure with cursor "anonymous block completed"

Vote count:

0

I've been trying to get this procedure working for the last few hours:

CREATE OR REPLACE PROCEDURE Search_Testimonials(keyword VARCHAR2)
AS
l_cursor_1 SYS_REFCURSOR;
Temp_Content VARCHAR(255);
BEGIN
   OPEN l_cursor_1 FOR
      SELECT T_Content
      INTO Temp_Content
      FROM Testimonial
      WHERE T_Content LIKE '%' || Keyword || '%';
      dbms_output.put_line(Temp_Content);
   DBMS_SQL.RETURN_RESULT(l_cursor_1);
END;

It's pretty much supposed to run through the testimonials table and output every row that has an instance of the keyword in the parameter. It compiles with no errors but when i execute like so:

EXECUTE Search_Testimonials('someword');

I get this error: "anonymous block completed". Does anyone know what's going on? I'm new to PL/SQL and am running out of resources on the internet or just don't understand what I'm reading.

-I'm running this all in oracle sql developer.

asked 56 secs ago

jktexas1

6

PL/SQL Procedure with cursor "anonymous block completed"