execute immediate in Oracle7.3.4

Hi ,

Is there a command that I can used to execute a dynamic sql in oracle 7.3.4 similar to the execute immediate command in 8.0 and above?

Thanks,

You have to use the DBMS_SQL package to dynamic SQL in Oracle 7.

Could you please give me an example to execute this statement

'CREATE TABLE temp (t_controlfile varchar2(30),
t_date date)';

Thanks a lot!!

Using DBMS_SQL ?
you must have access to this package first.


DECLARE
v_cursor INTEGER;
v_string VARCHAR2(100);
BEGIN
v_cursor := DBMS_SQL.OPEN_CURSOR;
v_string := 'CREATE TABLE temp (t_controlfile varchar2(30), t_date date)';
DBMS_SQL.PARSE(v_cursor, v_string, DBMS_SQL.NATIVE);
DBMS_SQL.CLOSE_CURSOR(v_cursor);
END;



F.