Error when invoking rqTableEval in R
Hello,
I have a problem with rqTableEval.
I am trying to execute a following PL/SQL block:
declare
cursor c1 is
SELECT
"id" AS id,
"x" AS x,
"y" AS y,
"level" AS z
FROM
TABLE
(
rqsys.rqTableEval (
CURSOR
(
SELECT
x AS "x",
y AS "y",
parameter_value AS "z",
5 AS "levels"
FROM
seis.geological_model_grid
WHERE
geological_model_data_id = 918
),
NULL,
'SELECT 1 "level", 2 "x", 3 "y", 4 "id" FROM dual',
'ContourPlotLines'
)
);
begin
for line in c1
loop
dbms_output.put_line(line.id);
end loop;
end;
And I gets an error ORA-00904:invalid identifier on the line with "rqsys.rqTableEval". If I execute select statement without cursor (outside of pl/sql block), everything is alright.
I have a problem with rqTableEval.
I am trying to execute a following PL/SQL block:
declare
cursor c1 is
SELECT
"id" AS id,
"x" AS x,
"y" AS y,
"level" AS z
FROM
TABLE
(
rqsys.rqTableEval (
CURSOR
(
SELECT
x AS "x",
y AS "y",
parameter_value AS "z",
5 AS "levels"
FROM
seis.geological_model_grid
WHERE
geological_model_data_id = 918
),
NULL,
'SELECT 1 "level", 2 "x", 3 "y", 4 "id" FROM dual',
'ContourPlotLines'
)
);
begin
for line in c1
loop
dbms_output.put_line(line.id);
end loop;
end;
And I gets an error ORA-00904:invalid identifier on the line with "rqsys.rqTableEval". If I execute select statement without cursor (outside of pl/sql block), everything is alright.
0