Search table data
862138May 31 2011 — edited May 31 2011Hi all,
I have a region in that i have autotextbox and search button, when the user enters a word in the autotextbox and presses the search button it should be able to retrive the corresponding values from the table according to the data entered in autotextbox. for example name a table A that it has a a column named name. When the user enters the word in the autotextbox and search it should retrive the name according to the word entered in the autotext box.
I have tried the following and got struct with the following error
error
ORA-06550: line 3, column 3: PLS-00103: Encountered the symbol "L_SQL" when expecting one of the following: := . ( @ % ; ORA-06550: line 8, column 6: PLS-00103: Encountered the symbol "BEGIN" when expecting one of the following: ; The symbol ";" was substituted for "BEGIN" to continue.
DECALRE
l_sql VARCHAR2(32700);
BEGIN
l_sql := 'select category_name from service_category where category_name:=p9_search';
*:p9_test1:=l_sql;*
END;
How can i retrive the data can anyone share your views.
Edited by: apex on May 31, 2011 3:51 AM