Can you send PL/SQL code and back-end code used this PL/SQL code?
Myself trubles with CURSOR I resolve use LIMIT ... OFFSET ...
Alla wrote:
> I am porting our database from Oracle to PostgreSQL
>
> I know quite a lot about Oracle and pretty much nothing about
> PostgreSQL :-))
>
> I have a lot of stored procedures in Oracle that return result sets or
> cursor. All I have to do there is open a cursor and calling
> application can just fetch it
>
> Is there anyway to do the same thing in PostgreSQL?
>
> Please, help. So far I could not find anything
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
