OraFAQ Forum: SQL & PL/SQL » HELP! variable in global temporary table

Home » SQL & PL/SQL » SQL & PL/SQL » HELP! variable in global temporary table

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

HELP! variable in global temporary table [message #37681]

Wed, 20 February 2002 11:17

sverch
Messages: 582
Registered: December 2000

Senior Member

When I try to execute procedure which populates global temporary table I get an error.
The following piece of code gives it to me. Apparently, Oracle does not recognize variables. I played with quotes and cancats. If anybody knows how to pass variables to ddl
statement within PL/SQL please respond.

(v_max_dt and v_case_boi were declared)

execute immediate 'insert into ' ||V_TB_NAME ||
' select a.case_nmbr, b.case_id,
FROM tbl a, tbl1 b
WHERE a.case_nmbr=b.case_nmbr
AND ...different conditions
AND (v_max_dt BETWEEN a.begin_date and a.end_date))
AND a.case_nmbr = v_case_boi ';

ERROR at line 1:
ORA-00904: invalid column name
ORA-06512: at line 29.

Report message to a moderator

Re: HELP! variable in global temporary table [message #37689 is a reply to message #37681]

Thu, 21 February 2002 06:36

Suresh Vemulapalli
Messages: 624
Registered: August 2000

Senior Member

execute immediate 'insert into ' ||V_TB_NAME ||
' select a.case_nmbr, b.case_id,
FROM tbl a, tbl1 b
WHERE a.case_nmbr=b.case_nmbr
AND ...different conditions
AND ('||''''||v_max_dt||''''||' BETWEEN a.begin_date and a.end_date))
AND a.case_nmbr = '||v_case_boi;

Report message to a moderator