dynamic sql in proc [message #71654] |
Tue, 10 December 2002 22:06 |
srivani
Messages: 3 Registered: December 2002
|
Junior Member |
|
|
hi
I have got a problem when iam doing the proc programusing dynamic method3.
I have prepared a statement using a select statement that has nearly 13 fields.WHen i run the program it is giving memory core dump...
how can i solve the problem.
I have to select all the feilds and create a cursor from that
please tell me the solution
thanks and regards
vani
|
|
|
Re: dynamic sql in proc [message #71672 is a reply to message #71654] |
Sun, 15 December 2002 09:10 |
vamsi krishna
Messages: 1 Registered: December 2002
|
Junior Member |
|
|
i don't think the problem is phyiscal one.i think problem is thr in joins.even the selected feilds may be 100 no problem.first check the joins and
constraints.
all the best
|
|
|