Database DataWarehousing (MOSC)

MOSC Banner

Error when invoking rqTableEval in R

edited Mar 31, 2013 5:06PM in Database DataWarehousing (MOSC) 2 commentsAnswered
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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center