Please Help ! Urgent - [message #41249] |
Thu, 12 December 2002 02:52 |
mousie
Messages: 9 Registered: March 2002
|
Junior Member |
|
|
Hi everyone - Hope you're well.
I've got a problem with dbms_sql. I use it in Oracle 7 and then i have these statements :
var1 dbms_sql.varchar2s;
dbmssql interger;
line_flag boolean:=true;
i, j integer;
var(1):='declare';
var(2):='begin';
...
var(5):='end;';
i:=1;
j:=5;
dbmssql:=dbms_sql.open_cursor;
dbms_sql.parse(dbmssql,sqlstring,i,j,line_flag,DBMS_SQL.V7);
retval:=dbms_sql.execute(dbmssql);
dbms_sql.close_cursor(dbmssql);
It works well. But we migrate in Oracle8 and this will
not work I think.
Can someone tell me the statements i must change to make it work in Ora8 ?
I'll really appreciate your help
Thanks !
|
|
|
|