Re: Dynamic SQL method 2

From: Greg Forestieri <gforestieri9_at_yahoo.com>
Date: 25 Jun 2003 07:51:48 -0700
Message-ID: <6a8cdd95.0306250651.20daa58b@posting.google.com>

adam_at_ddisolutions.com.au (Adam C) wrote in message news:<8bdc35cd.0306242110.6d979c6c_at_posting.google.com>...
> Hi All {Platform Win2kPro and Oracle8i),
>
> I am having some problems with executing dynamic sql from within a function.
> If i copy the code into SQL*Plus it executes and inserts a record, however
> when I run this from the function it executes (no exception) and DOES NOT
> insert a record! Here is an example of the code that I am using:
snip

It would be nice to actually see this "function", rather than just the code snippet.

Greg Received on Wed Jun 25 2003 - 09:51:48 CDT