| DBMS_SQL [message #40319] |
Fri, 27 September 2002 02:26  |
shyampaliyath
Messages: 22
Registered: May 2002
|
Junior Member |
|
|
greetings
i have written this below coding in forms 6i. The code does not show any error but the query is not executed
declare
op_cursor number;
query_sql varchar2(5000);
r_value number;
begin
op_cursor:=dbms_sql.open_cursor;
query_sql:= :blk_excel.txt_sql;
message(query_sql);
dbms_sql.parse(op_cursor,query_sql,0);
r_value:=dbms_sql.execute(op_cursor);
dbms_sql.close_cursor(op_cursor);
message('over');
end;
i am entering
"insert into emp select * from t1" in the :blk_excel.txt_sql. this query is properly executed in the oracle which i have checked.
regards
Shyam
|
|
|
|
| Re: DBMS_SQL [message #40328 is a reply to message #40319] |
Fri, 27 September 2002 14:15  |
Mrinal Hazarika
Messages: 3
Registered: September 2002
|
Junior Member |
|
|
Your code should give compilation error for not recognizing :blk_excel.txt_sql
Provided emp and t1 table exist and of same structure ..
Following should work
declare
op_cursor number;
query_sql varchar2(5000);
r_value number;
begin
op_cursor:=dbms_sql.open_cursor;
query_sql:= 'insert into emp select * from t1';
/*message(query_sql); */
dbms_sql.parse(op_cursor,query_sql,0);
r_value:=dbms_sql.execute(op_cursor);
dbms_sql.close_cursor(op_cursor);
/* message('over'); */
end;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
