Re: pl/sql simple prob but .....

Ravi,
  You must use the DBMS_SQL package for substitution of table names and database links. This can be found in the Oracle Administator Guide or its addendum. This package follows the same process as in the OCI calls for C and Fortran. Steps:

1. Open a cursor.
2. Parse the SQL statement into the cursor
3. Substitute Values for placeholders
4. Execute cursor.
5. Close cursor. If you are expecting information back you must also substitute resulting fields from the select statement with memory variables.
6. Kim Hughes Managing Consultant DRT Systems Houston, TX (713)868-5537