Re: pl/sql problem

From: <bonanos_at_yahoo.com>
Date: Fri, 28 Aug 1998 07:12:20 GMT
Message-ID: <6s5l8k$g31$1@nnrp1.dejanews.com>

> 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;

You have to use dynamic SQL dbms_SQL, good luck

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Fri Aug 28 1998 - 02:12:20 CDT