Tablename as a Parameter in stored procedures
From: Jochen Pege <pege_at_kespretlang.de>
Date: Thu, 7 Dec 2000 12:45:54 +0100
Message-ID: <90ntcg$3qm$1_at_news10.roka.net>
Date: Thu, 7 Dec 2000 12:45:54 +0100
Message-ID: <90ntcg$3qm$1_at_news10.roka.net>
Hi everybody,
I have a problem with my stored procedure (sp). To make it generally valid I
want to give the sp the Tablename as a parameter.
May I call the parameter v_tab and it is a varchar2.
In the sp I have a query, something like
Select bla, bla from v_tab
This occurs an Errormessage: PLS-00201 identifier 'string' must be declared
Where is my mistake?
Jochen
Received on Thu Dec 07 2000 - 12:45:54 CET