giving tablenames to functions or procedures

From: Michael Brohl <michael.brohl_at_t-online.de>
Date: 1998/04/08
Message-ID: <6gftht$pbt$1_at_news00.btx.dtag.de>#1/1


[Quoted] [Quoted] Is there any way to give tablenames to functions or [Quoted] 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 Wed Apr 08 1998 - 00:00:00 CEST

Original text of this message