Can I use table name as variable in PRO*C/PLSQL?

MA Qiang — Sat, 21 May 2005 07:54:26 GMT

EXEC SQL INSERT
INTO tbl_X VALUES (:test_rec);
EXEC SQL COMMIT WORK;

IF tbl_X is a variable, how to set and use it?

Best Regards.

Re: Can I use table name as variable in PRO*C/PLSQL?

Alex Lavrov. — Sat, 21 May 2005 09:14:11 GMT

Hey,

It's called dynamic sql. In pl/sql it's easy, but it's a bit more complicated in proc*c.

Here's for Pro*C:
http://www.stanford.edu/dept/itss/docs/oracle/9i/appdev.920/a97269/pc_13dyn.htm

Here's for PL/SQL:
http://www.dulcian.com/magazine%20articles/Execute%20Immediate.htm
(immediate statement)

But remember, heavy use of dynamic sql, can cause performance problems. The switch between static and dynamic sql impacts oerformance.