From: Alan.Mills@xservices.pants.fujitsu.com   
      
   "Sugus"  wrote in message   
   news:76f56553.0308290221.4b4a65f3@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   
      
   you would have to use dynamic SQL for this.  The parameter would then simply   
   be a VARCHAR2 type, i.e., string.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)