pl/sql problem

Hi:

I have a pl/sql problem.

When I did:

CREATE OR REPLACE ... IS

CURSOR 1_cursor IS

	select ...
	from table_1
	where client in ('A','B','C')
	  and ..


	...

BEGIN         for c1 in 1_cursor loop

....
        

        end loop;
END; Everything works fine. But when I have to do like:

CREATE OR REPLACE .. IS

	all_client	VARCHAR2(512);
	CURSOR 1_cursor IS
		select ...
		from table_1
		where client in (all_client)
		  and ...
		...

BEGIN
	all_client := '''A'',''B'',''C''';

	for c1 in 1_cursor loop



	.......



	end  loop;

.....

END; It returns nothing.

Could someone tell me what's the problem?

Thanks. Received on Wed Aug 26 1998 - 17:23:51 CDT