var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: errors when running a procedure
first time posting here, i'm nervous!? ~"~
anyways, the procedure searches the table testimonials that has testimonies that matches the search key.
CREATE OR REPLACE Procedure searchTestimonies( searchee varchar2) IS
v_searchee:='%'|| searchee ||'%';
'CREATE OR REPLACE VIEW search_view AS
SELECT * FROM Testimonials
WHERE Testimonies LIKE ' || v_searchee ||'
OR Member_Number LIKE ' || v_searchee;
i don't know if i wrote the procedure wrong or what
but when i do something like
i get the following:
ERROR at line 1:
ORA-00911: invalid character
ORA-06512: at "SYSTEM.SEARCHTESTIMONIES", line 9
ORA-06512: at line 1
thanks a lot in advance
Last edited by krispyCake; 11-17-10 at 05:05.
No, it doesn't
Originally Posted by krispyCake
It creates (or tries to create) a VIEW that will run the corresponding SELECT, but it will not run that SELECT statement.
Please use [code] tags to format your code so that we have chance to see what line 9 really is.
Tags for this Thread