| i need the solution to the following query [message #370947] |
Sat, 11 March 2000 03:13  |
shravan
Messages: 13
Registered: March 2000
|
Junior Member |
|
|
CREATE procedure search1 @input varchar(10)
as
SELECT firstname, lastname
FROM customerinfo
where contains (firstname , ' @input' )
this gives me no complilation errors.
but does not display the results
|
|
|
|
| Re: i need the solution to the following query [message #370949 is a reply to message #370947] |
Sat, 11 March 2000 11:43  |
Suresh
Messages: 189
Registered: December 1998
|
Senior Member |
|
|
hi
try this
create procedure pr_name(param_ch varchar2) as
cursor c1(p char) is
select SELECT firstname, lastname
FROM customerinfo
where contains (firstname , p );
l_name varchar2(30);
begin
for myrec in c1(param_ch) loop
--process here
l_name := myrec.lastname;
end loop;
end;
Hope this helps
Suresh
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
