Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Accessing a cursor using dynamic SQL
mikeg13_at_gmail.com wrote:
> I am creating dynamic SQL, from the ALL_TAB_COLS table, and the output
> is unknown until runtime. My SELECT statement may select 4 columns, 20
> columns, or 200. Once I have built this SQL, how can I run it into a
> cursor? How do I define that cursor?
This is the definition of a bad idea. You have decided on a technology you don't know how to implement to solve a business problem that you don't state in a version of the database that is a secret.
What is the business case?
Sorry to be harsh but this has unscalable and bad performance written all over it.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Tue Jul 25 2006 - 23:30:42 CDT
![]() |
![]() |