Hi Guys,
I am new to oracle coding and I wrote this store procedure

PROCEDURE Get_Faq_Proc
       ( header_name in varchar2,
         out_faq_list OUT curTableList
       )
    IS
    BEGIN
         OPEN out_faq_list for
         select question , answer
         from faq_data
         where header_id = (select header_id from faq_header where title LIKE (''%' || header_name || '%'');

         end Get_Faq_proc;
And it comes up with an oracle error at like statement.
Any help would be appreciated.
Nitin

I think u need to create the SQL statement and store in a string and then execute the string.

Om Prakash

hi,

can you please send the error message that you are getting.



Ram

use,

PROCEDURE Get_Faq_Proc
       ( header_name in varchar2,
         out_faq_list OUT curTableList
       )
    IS
str varchar2(1000);
    BEGIN
str := 'select question , answer
         from faq_data
         where header_id = (select header_id from faq_header where title LIKE (''%'' || header_name || ''%'')';
         OPEN out_faq_list for str


         end Get_Faq_proc;


Sujit Ku. Mahapatra

use like operator this way-
like '%' || upper(header_name) || '%';

thr