Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Execute immediate
"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
news:3e428868$0$234$ed9e5944_at_reading.news.pipex.net...
> (though I still
> can't imagine why you would use execute immediate to run pl/sql).
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
I was curious myself too:
From: Oracle Built-in Packages - By Steven Feuerstein, Charles Dye, John
Beresniewicz (O'Reilly Books)
"In a database table you can store the names of procedures that perform
certain calculations. Then build a front-end to that table, which allows a
user to select the computation of interest, provide the inputs to that
program, and then execute it. When other computations need to be offered to
the user, you add a row in a table, instead of modifying one or more
screens."
Also some examples are shown for calling a specific procedure depending on
the data-meaning, e.g. looking up the appropriate function name in a table
depending on e.g. article class, making the call to the function using
dbms_sql.
Erik Ykema
Received on Thu Feb 06 2003 - 14:48:05 CST