Re: help!! How to set tablename variable?

What you are trying to do is execute DYNAMIC SQL. This is not directly supported. You need to use DBMS_SQL package to do so where you DEFINE, PARSE and then EXECUTE your sql statment, a little more coding.

If you use Oracle8i, it is simpler.

regards,
M. Armaghan Saqib

• SQL PlusPlus : Add power to SQL Plus command line
• SQL Link for XL : Integrate Oracle with XL
• Oracle CBT with sample GL (Triggers and Forms Source Code included. Download free: http://www.geocities.com/armaghan/

  ---

  lkw <lkw_at_axiomatique.com> wrote in message news:83a1c0 $otu$1_at_newton3.pacific.net.sg...
  > hi everybody,
  >
  > say i want to pass a tablename variable (v_tblname) into a stored
  procedure
  > to perform a sql statement.
  > Inside my stored proc i wrote:
  >
  > select * from v_tblname;
  >
  > but i always encountered errors. so i just want to know that is there
  a way
  > to set a table name as a variable? if yes, how?
  >
  > yr helf would be greatly appreciated!! thanks!!
  >
  > lkw.
  

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Dec 16 1999 - 01:53:47 CST