TableFunction "on the fly"

[Antonio Sala]

Hi:
In my application, I need to create complex queries that I solve frequently with tablefunctions.
But the oracle server is not administrated by my, and the creation of tablefunctions is delayed some days.
I tried to make, in a oracledataset this code:

begin
open :mycursor for select * from mytable ;
end;
The variable :mycursor is defined cursor type.
This works well, but is very simple.
Can I to make the same but more complicated?
For example:
begin
for :mycursor in (select * from mytable)
loop
:mycursor.myfield := 'myvalue';
end loop ;
end;
I have tried it but does not function.

 

[Marco Kalter]

This is not possible. You are restricted to a cursor result set, as returned by a SQL select statement.

On the other hand you can call PL/SQL functions in a select statement, so even more complex results may be possible.