Re: Can I do this with the dynamic SQL?

cschang wrote:
> I found an alternative for my last post, however, there was still a
> problem. I wrote a package with a procedure as
>
> Procedure abc( p_sa IN VARCHAR2) IS
> v_name tbl_name; -- is a table type variable decalred in package spec.
> BEGIN
> sqlStmt := 'select name from fl_management f, TABLE(f.mgmts_nt) f2
> where f2.sa= :x';
> If ... Then
> EXECUTE IMMEDIATE sqlStmt BULK COLLECT INTO v_name USING const1;
> ELSIF .. THEN
> EXECUTE IMMEDIATE sqlStmt BULK COLLECT INTO v_name USING const2;
> END IF;
> ...
> END abc;
> When I compiled this, the error showing BULK can not be used here. Can
> anyone tell me why? I did follow the syntax, did I? My setup is 8.1.7.4
> on NT 4 Thanks.
>
> C Chang
>

i'm not sure, but i think that BULK COLLECT in dynamic sql is available from 9i, so ...

maniek Received on Sat Jul 10 2004 - 04:16:31 CDT