Home -> Usenet -> comp.databases.oracle -> Cursor parameters - problems with 'FROM [inTablename]' statement

Cursor parameters - problems with 'FROM [inTablename]' statement

From: Sugus <krug_at_europ.de>
Date: 29 Aug 2003 03:21:21 -0700
Message-ID: <76f56553.0308290221.4b4a65f3_at_posting.google.com> 






I'd like to declare a cursor, which accepts parameters also for the
"FROM" tablename-clause, like:



CURSOR cFielddef(pfromTable IN ?????, pTableName IN VARCHAR2) IS 
SELECT column_name, data_type, data_length, nullable FROM pfromTable 
WHERE table_name = UPPER(pTableName);



Is it possible at all, and what type do I have to decalre in place of
the questionsmarks? Any other solution?



Thanks für your help,



Sugus
Received on Fri Aug 29 2003 - 12:21:21 CEST












Original text of this message