Re: giving tablenames to functions or procedures

use dynamic SQL

Michael Brohl wrote in message <6gftht$pbt$1_at_news00.btx.dtag.de>...
>Is there any way to give tablenames to functions or
>procedures and how can I refer to them?
>
>e.g.
>
> create function Test
> (cTabName CHAR)
> RETURN CHAR IS
> .
> .
> BEGIN
> .
> .
> SELECT Testfield FROM cTabName;
> .
> .
> END;
> /
>
>This example doesn't work, because the compiler didn't know
>if the specified table is accessable at runtime.
>
>Any hints?
>
>Thanks,
>
> Michael
>
>---
> Fido: 2:2449/480.3
> Email: michael.brohl_at_usa.net
> Homepage: http://home.t-online.de/home/michael.brohl
>
Received on Thu Apr 09 1998 - 00:00:00 CDT