| Subject | Re: [firebird-support] Dynamic stored procedure? |
|---|---|
| Author | Helen Borrie |
| Post date | 2006-03-07T21:30:01Z |
At 02:44 AM 8/03/2006, you wrote:
You can't pass database objects as variables: but you may pass the
object identifier as a string and morph it into another string to be
passed to an EXECUTE STATEMENT statement.
./heLen
>Hi everyoneYes, it's possible, as long as you are using Fb 1.5 or higher.
>
>Is it possible to pass variables into a stored procedure that can be
>used as the names of fields or tables, so that the same stored
>procedure can effectively be used on different tables?
You can't pass database objects as variables: but you may pass the
object identifier as a string and morph it into another string to be
passed to an EXECUTE STATEMENT statement.
>Maybe it is possible to put together sql strings in a stored procedureRead the documentation in the Fb 1.5 release notes. *DO NOT USE for DDL*
>that can then somehow be executed in the procedure itself?
./heLen