Re: Setting bind variables or defines from applications?

On 20 Apr 2006 14:51:54 -0700, "dean" <deanbrown3d_at_yahoo.com> wrote:

>Now, what I really would love is to be able to set a define in my
>application, to point to the current output set, and then not have to
>send in the output set to all the SQL statements we generate.
>
>Sorry for the above, I realize now that its not bind variables, but
>definitions.

Actually, it is not definitions. It is misusing a RDBMS as a garbage bin, because nobody knew how to come up with a proper database design. The approach you seem to advocate is typically for a 3 GL application, and doesn't have to do anything with a RDBMS, except that you use RDBMS as storage.
I suggest you convert the application to 3GL, so you could use environment variables (Unix/Windows) or logicals (VMS).

Other than that you would need to create a separate *schema* for every 'set' , or come up with a bunch of UNION statements combining all ' sets' making sure your where clause selects the correct 'set' automatically.
Hopefully I don't have to explain to you that both of these approaches suck big time, and won't perform sufficiently *ever* (been there, done that, at a site, where they were equally smart).

--
Sybrand Bakker, Senior Oracle DBA