Home » RDBMS Server » Server Administration » DBMS_SQL V7 parameter error
DBMS_SQL V7 parameter error [message #370851] Fri, 18 February 2000 05:23 Go to next message
Ajay Madan
Messages: 8
Registered: January 2000
Junior Member
My database is Oracle 8i and the front end if forms6. I have to dynamically call a procedure, whose name is stored in a table in the database. I tried to use the DBMS_SQL with the following piece of code:

declare
val varchar2(10);
n integer;
cid integer;
begin
select fveod_programid into val from tsys_eod;
cid:=dbms_sql.open_cursor;
dbms_sql.parse(cid,val,dbms_sql.v7);
n:=dbms_sql.execute(cid);
dbms_sql.close_cursor(cid);
end;

But I am getting the following error:

ERROR:
error 512 at line 23, column 34
implementation restriction:'DBMS_SQL.V7: Cannot directly access remote package variable or cursor

What is the solution for the above problem?
Re: DBMS_SQL V7 parameter error [message #370872 is a reply to message #370851] Mon, 28 February 2000 13:38 Go to previous message
Naveen Kumar V
Messages: 16
Registered: February 2000
Junior Member
declare
val varchar2(10);
stmt varchar2(200);
n integer;
cid integer;
Try this out, this may help you out.
begin
select fveod_programid into val from tsys_eod;
cid:=dbms_sql.open_cursor;
stmt := 'begin '||val||' end ';
dbms_output.put_line(stmt);
dbms_sql.parse(cid,stmt,dbms_sql.v7);
n:=dbms_sql.execute(cid);
dbms_sql.close_cursor(cid);
end;
Previous Topic: Strange circumstance with Oracle Error Code 604: Please Help
Next Topic: LONG datatype
Goto Forum:
  


Current Time: Wed Oct 28 07:20:15 CDT 2020