PL/SQL Cursor

 How can i use commpile this cursor.
 I want to use a parameter to query a specific user table.

 cursor a(user_name in varchar2) is
 select * from user_name||'.'||table_name;  b a%ROWTYPE;

 I can select data when i use SQL Plus so  i know it is a syntax problem.

 Thank you very much.   Received on Wed Jun 16 1999 - 13:34:07 CDT