Home » RDBMS Server » Server Utilities » dynamic sql in proc
dynamic sql in proc [message #71654] Tue, 10 December 2002 22:06 Go to next message
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 Go to previous message
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
Previous Topic: Loading conditionally !
Next Topic: fatal error while exporting table
Goto Forum:
  


Current Time: Wed May 15 12:59:22 CDT 2024