R,
This would work. You need the package to return the result back into - note
the global v_into variable at the package spec level. I don't think it
would work the way you had set it up originally because the inner exec
immediate would not find the v_into variable.
Good Luck!
PS - WHY do you
turning a dynamic sql into dynamic pl/sql since this type of dynamic
sql does not work. Its rather cleaver.
From: Mercadante, Thomas F [EMAIL PROTECTED]
Date: 2003/07/18 Fri AM 11:59:32 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: help with dynamic pl/sql
]
cc:
Subject:Re: RE: help with dynamic pl/sql
i should have seen that one... error looks like it wasnt seeing the
variable.
If you do a google search for the online journal 'Oracle Professional'.
Steve Fuerstein has an article where he shows you how to do method 4
dynamic
It looks like you have to join, but the article can be found here:
Method 4 Dynamic SQL with Native Dynamic SQL (online subscribers only)
http://www.oracleprofessionalnewsletter.com/OP/OPmag.nsf/Index/594D98A6AF90025185256D32006A41CE
-Original Message-
From: [EMAIL PROTECTED]