Questions about the use of parameterized cursors for oracle8i

cursor pdct-parameter-cur (id varchar,price number)

is select * from productinfowhere productid like id \\'%'

and productprice>price;

A parameterized cursor is declared, where productid like id ||'%'Here, add a "%" wildcard to the end of the actual value of the parameter id to match it. If the id is passed in the value is'123456', that condition is equivalent to where productid like'123456%' 。

This is the meaning of defining the fields used in the table in the cursor, and assigning values to him to initialize...

There should be something wrong with this sentence:

str:='select ename from where ename like ''%'||letter||'%''';

Cursors can be declared with variables.

cursor cur(letter varchar2) is

select ename from where ename like ‘%letter||'%'

I would also like to know how to define it, how did this problem later be solved? Can you share that?

Parameter or field? The compilers must have been confused by you :

cursor cur_goods(p_categoryid varchar) is

select * from

select * from goods gwhere order by asc

where rownum<2;

Change it to this and you'll be fine.

I'll write you an example.

create or replace procedure test1（cursor1 out sys_refcursor）is

beginopen cursor1 for select * from table name;

end；Then go to this cursor in the program you are calling.

Look for the oracle book yourself, this is not clear.

This is the ordinary saving process.