Forms 6i - Ref Cursors

[Creepers]

I am passing a strong ref cursor from a package to Oracle Forms. Then iterating through to populate a data block. How can I dynamically create the Order By clause of the Ref Cursor?

 

[sem]

You may pass this clause to the procedure as a parameter. Once the forms block is created you don't need strong cursor anymore thus may edit your code and add some dynamic sql.

Regards, Dima

http://seminihin.narod.ru