-
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,
leonard905
leonard905@yahoo.com
-
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!!
leonard905
leonard905@yahoo.com
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|