vendredi 31 octobre 2014

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







PL/SQL Procedure with cursor "anonymous block completed"

Aucun commentaire:

Enregistrer un commentaire