| DBMS_SQL V7 parameter error [message #370851] |
Fri, 18 February 2000 05:23  |
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  |
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;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
