Home » RDBMS Server » Server Administration » i need the solution to the following query
i need the solution to the following query [message #370947] Sat, 11 March 2000 03:13 Go to next message
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 Go to previous message
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
Previous Topic: how do i call context sql query in the procedure which takes one input parameter
Next Topic: SQL Nav to run with Personal Oracle
Goto Forum:
  


Current Time: Sat Oct 24 04:15:14 CDT 2020