Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> giving tablenames to functions or procedures
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.brohlReceived on Wed Apr 08 1998 - 00:00:00 CDT