Re: Trouble executing data found on TABLE: exe_sel_dttime

From: Jaap W. van Dijk <j.w.vandijk.removethis_at_hetnet.nl>
Date: Thu, 03 Aug 2006 16:50:33 GMT
Message-ID: <44d228b9.666750@news.hetnet.nl>

On 30 Jul 2006 14:43:35 -0700, "nicolas246_at_gmail.com" <nicolas246_at_gmail.com> wrote:

>Hello,
>
>I want to execute using EXECUTE IMMEDIATE the data found on a table
>exe_sel_dttime_xml
>
>The following code inside a PLSQL procedure constantly gives me coding
>problems(therefore not working as it should!!):
>
>BEGIN
>FOR r
>IN (SELECT QUERY INTO v_toexecute FROM exe_sel_dttime_xml)

Lose the "INTO v_toexecute": the value of QUERY can be referenced inside the FOR-loop by r.QUERY

Jaap. Received on Thu Aug 03 2006 - 11:50:33 CDT

Re: Trouble executing data found on TABLE: exe_sel_dttime_xml (COLUMN: QUERY)