Advertisement

06.13.2008 at 08:07AM PDT, ID: 23482986
[x]
Attachment Details

ORA-01000: maximum open cursors exceeded

Asked by graham_ball in Oracle Database, PL / SQL

Tags: pl/sql, ORA-01000: maximum open cursors exceeded

The attached code is part of a stored procedure, which is where I'm getting the eeror.
Max cursors is set at 1024 and I just can't see how I'm going anywhere near that.

thanks for your help.Start Free Trial 
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
91:
92:
93:
94:
95:
96:
97:
98:
99:
100:
101:
102:
103:
104:
105:
106:
107:
108:
109:
110:
111:
112:
113:
114:
115:
116:
117:
118:
119:
120:
121:
122:
123:
124:
125:
126:
127:
128:
129:
130:
131:
132:
133:
134:
135:
136:
137:
138:
139:
140:
141:
142:
143:
144:
145:
146:
147:
148:
149:
150:
151:
152:
153:
154:
155:
156:
157:
158:
159:
160:
161:
162:
163:
164:
165:
166:
167:
168:
169:
170:
171:
172:
173:
174:
175:
176:
177:
178:
179:
180:
181:
182:
183:
184:
185:
186:
187:
188:
189:
190:
191:
192:
193:
194:
195:
196:
197:
198:
199:
200:
201:
202:
203:
204:
205:
206:
207:
208:
209:
210:
211:
212:
213:
214:
215:
216:
217:
218:
219:
220:
221:
222:
223:
224:
225:
226:
227:
228:
229:
230:
231:
232:
233:
234:
235:
236:
237:
238:
239:
240:
241:
242:
243:
244:
245:
246:
247:
248:
249:
250:
251:
252:
253:
254:
255:
256:
257:
258:
259:
260:
261:
262:
263:
264:
265:
266:
267:
268:
269:
270:
271:
272:
273:
274:
275:
276:
277:
278:
279:
280:
281:
282:
283:
284:
285:
286:
287:
288:
289:
290:
291:
292:
293:
294:
295:
296:
297:
298:
299:
300:
301:
302:
303:
304:
305:
306:
307:
308:
309:
310:
311:
312:
313:
314:
315:
316:
317:
318:
319:
320:
321:
322:
323:
324:
325:
326:
327:
328:
329:
330:
331:
332:
333:
334:
335:
336:
337:
338:

select TFF.FACTFIND_ID
				, SUBMISSIONS.SUBMISSION_NUMBER
			   , parties.cust1
			   , parties.cust2
			   , TFF.AGENT_ID
			   , null
			   , TFF.LEAD_ID
				, TFF.FACTFIND_DATE
			   , TFF.STATUS_DATE
			   , DECODE(SUBMISSIONS.SUBMISSION_NUMBER, 1,'Y','N') rft_flag
			   , needs.ip
			   , needs.ci
			   , needs.lcc
			   , needs.lci
			   , needs.savings
			   , needs.investment
			   , needs.pension
			   , needs.annuities
			   , sales.ip
			   , sales.ci
			   , sales.lcc
			   , sales.lci
			   , sales.savings
			   , sales.investment
			   , sales.pension
			   , sales.annuities
			   , EXPENDITURE.DECLINED_FLAG disclosed_expenditure
			   , ASSETS.DECLINED_FLAG disclosed_assets
			   , LIABILITIES.DECLINED_FLAG disclosed_liabilities
			   , OCCBEN.DECLINED_FLAG disclosed_occbens
			   , protection.DECLINED_FLAG disclosed_protection
			   , savings.DECLINED_FLAG disclosed_savings
			   , pensions.DECLINED_FLAG disclosed_pensions
			   , investments.DECLINED_FLAG disclosed_investments
			   , TFF.BUILDINGS_RENEWAL_DATE
			   , TFF.BUILDINGS_PROVIDER_TEXT
			   , TFF.CONTENTS_RENEWAL_DATE
			   , TFF.CONTENTS_PROVIDER_TEXT
			   , b_and_c_premium.premium
			   , atr.cust1_protection_level
			   , atr.cust1_savings_level
			   , atr.cust1_investment_level
			   , atr.cust1_pension_level
			   , cust_ni.cust1_ip_ni
			   , cust_ni.cust1_ci_ni
			   , cust_ni.cust1_lcc_ni
			   , cust_ni.cust1_lci_ni
			   , cust_ni.cust1_savings_ni
			   , cust_ni.cust1_investments_ni
			   , cust_na.cust1_ip_na
			   , cust_na.cust1_ci_na
			   , cust_na.cust1_lcc_na
			   , cust_na.cust1_lci_na
			   , cust_na.cust1_savings_na
			   , cust_na.cust1_investments_na
			   , atr.cust2_protection_level
			   , atr.cust2_savings_level
			   , atr.cust2_investment_level
			   , atr.cust2_pension_level
			   , cust_ni.cust2_ip_ni
			   , cust_ni.cust2_ci_ni
			   , cust_ni.cust2_lcc_ni
			   , cust_ni.cust2_lci_ni
			   , cust_ni.cust2_savings_ni
			   , cust_ni.cust2_investments_ni
			   , cust_na.cust2_ip_na
			   , cust_na.cust2_ci_na
			   , cust_na.cust2_lcc_na
			   , cust_na.cust2_lci_na
			   , cust_na.cust2_savings_na
			   , cust_na.cust2_investments_na
			   , TFF.STATUS_DATE
			from salex.t_ff_factfind@util.world tff
				,(
			      select TNLD.FACTFIND_ID
			      , MAX(TNLD.SUBMISSION_NUMBER) submission_number
			      from salex.t_nbmu_log_detail@util.world tnld
			      group by TNLD.FACTFIND_ID
			    ) submissions
				,(
			      select TFR.FACTFIND_ID
			         , MAX(DECODE(TFR.ROLE_TYPE_CODE_ID,1008513,TFR.PARTY_ID )) cust1
			         , MAX(DECODE(TFR.ROLE_TYPE_CODE_ID,1008514,TFR.PARTY_ID )) cust2
			      from salex.t_ff_role@util.world tfr
			      group by TFR.FACTFIND_ID
			    )  parties
				,(
				   select tna.factfind_id
						, NVL(SUM(DECODE(TNND.NEED_ID,341,1)),0) ip
						, NVL(SUM(DECODE(TNND.NEED_ID,342,1)),0) ci
						, NVL(SUM(DECODE(TNND.NEED_ID,343,1,8,1)),0) lcc
						, NVL(SUM(DECODE(TNND.NEED_ID,340,1)),0) lci
						, NVL(SUM(DECODE(TNND.NEED_ID,346,1)),0) annuities
						, NVL(SUM(DECODE(TNND.NEED_ID,347,1,348,1)),0) savings
						, NVL(SUM(DECODE(TNND.NEED_ID,349,1,350,1)),0) investment
						, NVL(SUM(DECODE(TNND.NEED_ID,344,1,345,1)),0) pension
					from salex.t_na_needs@util.world tna
						, salex.t_na_needs_detail@util.world tnnd
					where TNA.NA_NEED_ID = TNND.NA_NEED_ID
					group by tna.factfind_id
				 ) needs
				,(
					select tr.factfind_id
						, NVL(SUM(DECODE(tr.NEED_ID,341,1)),0) ip
						, NVL(SUM(DECODE(tr.NEED_ID,342,1)),0) ci
						, NVL(SUM(DECODE(tr.NEED_ID,343,1,8,1)),0) lcc
						, NVL(SUM(DECODE(tr.NEED_ID,340,1)),0) lci
						, NVL(SUM(DECODE(tr.NEED_ID,346,1)),0) annuities
						, NVL(SUM(DECODE(tr.NEED_ID,347,1,348,1)),0) savings
						, NVL(SUM(DECODE(tr.NEED_ID,349,1,350,1)),0) investment
						, NVL(SUM(DECODE(tr.NEED_ID,344,1,345,1)),0) pension
					from salex.t_recommendations@util.world tr
					where TR.FACTFIND_ID is not null
					and TR.ACCEPTED_CODE_ID = 590
					group by tr.factfind_id
				 ) sales
			   ,(
			      select distinct TFIE.FACTFIND_ID
			            , TFIE.DECLINED_FLAG
			      from salex.t_ff_income_expenditure@util.world tfie
				 ) expenditure
			   ,(
			      select distinct TFA.FACTFIND_ID
			            , TFA.DECLINED_FLAG
			      from salex.t_ff_assets@util.world tfa
				 ) assets
			   ,(
					select distinct TFL.FACTFIND_ID
			            , TFL.DECLINED_FLAG
			      from salex.t_ff_liabilities@util.world tfl
				 ) liabilities
			   ,(
			      select distinct TFOB.FACTFIND_ID
			            , TFOB.DECLINED_FLAG
			      from salex.t_ff_occupational_benefits@util.world tfob
				 ) occben
			   ,(
			      select distinct TFEB.FACTFIND_ID
			            , MAX(TFEB.DECLINED_FLAG) DECLINED_FLAG
			      from salex.t_ff_existing_business@util.world tfeb
			      where TFEB.NEED_AREA_CODE_ID = 1008499
			      group by tfeb.factfind_id
				 ) protection
			   ,(
			      select distinct TFEB1.FACTFIND_ID
			            , MAX(TFEB1.DECLINED_FLAG) DECLINED_FLAG
			      from salex.t_ff_existing_business@util.world tfeb1
			      where TFEB1.NEED_AREA_CODE_ID = 1008500
			      group by tfeb1.factfind_id
				 ) savings
			   ,(
			      select distinct TFEB2.FACTFIND_ID
			            , MAX(TFEB2.DECLINED_FLAG) DECLINED_FLAG
			      from salex.t_ff_existing_business@util.world tfeb2
			      where TFEB2.NEED_AREA_CODE_ID = 1008501
			      group by tfeb2.factfind_id
				 ) pensions
			   ,(
			      select distinct TFEB3.FACTFIND_ID
			            , MAX(TFEB3.DECLINED_FLAG) DECLINED_FLAG
			      from salex.t_ff_existing_business@util.world tfeb3
			      where TFEB3.NEED_AREA_CODE_ID = 1008502
			      group by tfeb3.factfind_id
				 ) investments
			   ,(
			      select TFIE1.FACTFIND_ID
			         , SUM(TFIED1.IE_AMT) premium
			      from salex.t_ff_income_expenditure@util.world tfie1
			         , salex.t_ff_income_exp_detail@util.world tfied1
			      where TFIE1.IE_ID = TFIED1.IE_ID
			      and TFIE1.DECLINED_FLAG = 'N'
			      and TFIED1.IE_CODE_ID = 1008556
			      group by TFIE1.FACTFIND_ID
			   ) b_and_c_premium
			   ,(
			      select factfind_id
			            , MAX(DECODE(ROLE_TYPE_CODE_ID||ni_type,'1008513IP','Y')) cust1_ip_ni
			            , MAX(DECODE(ROLE_TYPE_CODE_ID||ni_type,'1008513CI','Y')) cust1_ci_ni
			            , MAX(DECODE(ROLE_TYPE_CODE_ID||ni_type,'1008513LCC','Y')) cust1_lcc_ni
			            , MAX(DECODE(ROLE_TYPE_CODE_ID||ni_type,'1008513LCI','Y')) cust1_lci_ni
			            , MAX(DECODE(ROLE_TYPE_CODE_ID||ni_type,'1008513Savings','Y')) cust1_savings_ni
			            , MAX(DECODE(ROLE_TYPE_CODE_ID||ni_type,'1008513Investments','Y')) cust1_investments_ni
			            , MAX(DECODE(ROLE_TYPE_CODE_ID||ni_type,'1008514IP','Y')) cust2_ip_ni
			            , MAX(DECODE(ROLE_TYPE_CODE_ID||ni_type,'1008514CI','Y')) cust2_ci_ni
			            , MAX(DECODE(ROLE_TYPE_CODE_ID||ni_type,'1008514LCC','Y')) cust2_lcc_ni
			            , MAX(DECODE(ROLE_TYPE_CODE_ID||ni_type,'1008514LCI','Y')) cust2_lci_ni
			            , MAX(DECODE(ROLE_TYPE_CODE_ID||ni_type,'1008514Savings','Y')) cust2_savings_ni
			            , MAX(DECODE(ROLE_TYPE_CODE_ID||ni_type,'1008514Investments','Y')) cust2_investments_ni
			      from 
			      (
			              select 'IP' ni_type  
			                  , tnipp.FACTFIND_ID
			                  , tfr1.ROLE_TYPE_CODE_ID
			              from salex.t_na_ipp@util.world tnipp
			                  , salex.t_ff_role@util.world tfr1  
			              where tnipp.not_important_flag = 'Y'
			              and TNIPP.FACTFIND_INDIVIDUAL_ID = tfr1.FACTFIND_INDIVIDUAL_ID  
			              union  
			              select 'CI'  
			                  , tnci.FACTFIND_ID  
			                  , tfr1.ROLE_TYPE_CODE_ID
			              from salex.t_na_cic@util.world tnci  
			                  , salex.t_ff_role@util.world tfr1  
			              where tnci.not_important_flag = 'Y'  
			              and tnci.FACTFIND_INDIVIDUAL_ID = tfr1.FACTFIND_INDIVIDUAL_ID  
			              union  
			              select 'LCC'  
			                  , tnc.FACTFIND_ID  
			                  , tfr1.ROLE_TYPE_CODE_ID
			              from salex.t_na_capital@util.world tnc  
			                  , salex.t_ff_role@util.world tfr1  
			              where tnc.not_important_flag = 'Y' 
			              and tnc.FACTFIND_INDIVIDUAL_ID = tfr1.FACTFIND_INDIVIDUAL_ID  
			              union  
			              select 'LCI'  
			                  , tnlc.FACTFIND_ID  
			                  , tfr1.ROLE_TYPE_CODE_ID
			              from salex.t_na_life_cover@util.world tnlc  
			                  , salex.t_ff_role@util.world tfr1  
			              where tnlc.not_important_flag = 'Y'  
			              and tnlc.FACTFIND_INDIVIDUAL_ID = tfr1.FACTFIND_INDIVIDUAL_ID  
			              union  
			              select 'Savings'  
			                  , tns.FACTFIND_ID  
			                  , tfr1.ROLE_TYPE_CODE_ID
			              from salex.t_na_savings@util.world tns  
			                  , salex.t_ff_role@util.world tfr1  
			              where tns.not_important_flag = 'Y'  
			              and tns.FACTFIND_INDIVIDUAL_ID = tfr1.FACTFIND_INDIVIDUAL_ID  
			              union  
			              select 'Investments'  
			                  , tni.FACTFIND_ID  
			                  , tfr1.ROLE_TYPE_CODE_ID
			              from salex.t_na_investments@util.world tni  
			                  , salex.t_ff_role@util.world tfr1  
			              where tni.not_important_flag = 'Y' 
			              and tni.FACTFIND_INDIVIDUAL_ID = tfr1.FACTFIND_INDIVIDUAL_ID  
			      )
			      group by factfind_id
			  	 ) cust_ni
			   ,(
			      select factfind_id
			            , MAX(DECODE(ROLE_TYPE_CODE_ID||na_type,'1008513IP','Y')) cust1_ip_na
			            , MAX(DECODE(ROLE_TYPE_CODE_ID||na_type,'1008513CI','Y')) cust1_ci_na
			            , MAX(DECODE(ROLE_TYPE_CODE_ID||na_type,'1008513LCC','Y')) cust1_lcc_na
			            , MAX(DECODE(ROLE_TYPE_CODE_ID||na_type,'1008513LCI','Y')) cust1_lci_na
			            , MAX(DECODE(ROLE_TYPE_CODE_ID||na_type,'1008513Savings','Y')) cust1_savings_na
			            , MAX(DECODE(ROLE_TYPE_CODE_ID||na_type,'1008513Investments','Y')) cust1_investments_na
			            , MAX(DECODE(ROLE_TYPE_CODE_ID||na_type,'1008514IP','Y')) cust2_ip_na
			            , MAX(DECODE(ROLE_TYPE_CODE_ID||na_type,'1008514CI','Y')) cust2_ci_na
			            , MAX(DECODE(ROLE_TYPE_CODE_ID||na_type,'1008514LCC','Y')) cust2_lcc_na
			            , MAX(DECODE(ROLE_TYPE_CODE_ID||na_type,'1008514LCI','Y')) cust2_lci_na
			            , MAX(DECODE(ROLE_TYPE_CODE_ID||na_type,'1008514Savings','Y')) cust2_savings_na
			            , MAX(DECODE(ROLE_TYPE_CODE_ID||na_type,'1008514Investments','Y')) cust2_investments_na
			      from 
			      (
			              select 'IP' na_type  
			                  , tnipp1.FACTFIND_ID
			                  , tfr2.ROLE_TYPE_CODE_ID
			              from salex.t_na_ipp@util.world tnipp1
			                  , salex.t_ff_role@util.world tfr2
			              where tnipp1.NOT_APPLICABLE_FLAG = 'Y'
			              and tnipp1.FACTFIND_INDIVIDUAL_ID = tfr2.FACTFIND_INDIVIDUAL_ID  
			              union  
			              select 'CI'  
			                  , tnci1.FACTFIND_ID  
			                  , tfr2.ROLE_TYPE_CODE_ID
			              from salex.t_na_cic@util.world tnci1 
			                  , salex.t_ff_role@util.world tfr2 
			              where tnci1.NOT_APPLICABLE_FLAG = 'Y'  
			              and tnci1.FACTFIND_INDIVIDUAL_ID = tfr2.FACTFIND_INDIVIDUAL_ID  
			              union  
			              select 'LCC'  
			                  , tnc1.FACTFIND_ID  
			                  , tfr2.ROLE_TYPE_CODE_ID
			              from salex.t_na_capital@util.world tnc1 
			                  , salex.t_ff_role@util.world tfr2
			              where tnc1.NOT_APPLICABLE_FLAG = 'Y' 
			              and tnc1.FACTFIND_INDIVIDUAL_ID = tfr2.FACTFIND_INDIVIDUAL_ID  
			              union  
			              select 'LCI'  
			                  , tnlc1.FACTFIND_ID  
			                  , tfr2.ROLE_TYPE_CODE_ID
			              from salex.t_na_life_cover@util.world tnlc1 
			                  , salex.t_ff_role@util.world tfr2
			              where tnlc1.NOT_APPLICABLE_FLAG = 'Y'  
			              and tnlc1.FACTFIND_INDIVIDUAL_ID = tfr2.FACTFIND_INDIVIDUAL_ID  
			              union  
			              select 'Savings'  
			                  , tns1.FACTFIND_ID  
			                  , tfr2.ROLE_TYPE_CODE_ID
			              from salex.t_na_savings@util.world tns1 
			                  , salex.t_ff_role@util.world tfr2 
			              where tns1.NOT_APPLICABLE_FLAG = 'Y'  
			              and tns1.FACTFIND_INDIVIDUAL_ID = tfr2.FACTFIND_INDIVIDUAL_ID  
			              union  
			              select 'Investments'  
			                  , tni1.FACTFIND_ID  
			                  , tfr2.ROLE_TYPE_CODE_ID
			              from salex.t_na_investments@util.world tni1 
			                  , salex.t_ff_role@util.world tfr2 
			              where tni1.NOT_APPLICABLE_FLAG = 'Y' 
			              and tni1.FACTFIND_INDIVIDUAL_ID = tfr2.FACTFIND_INDIVIDUAL_ID  
			      )
			      group by factfind_id
			  	 ) cust_na
			   ,(
			      select TNA2.FACTFIND_ID
			         , MAX(DECODE(TFR2.ROLE_TYPE_CODE_ID||TNA2.ATR_PRODUCT_TYPE_CODE_ID,10085131008768, TNA2.ATR_LEVEL)) cust1_protection_level
			         , MAX(DECODE(TFR2.ROLE_TYPE_CODE_ID||TNA2.ATR_PRODUCT_TYPE_CODE_ID,10085131008769, TNA2.ATR_LEVEL)) cust1_savings_level
			         , MAX(DECODE(TFR2.ROLE_TYPE_CODE_ID||TNA2.ATR_PRODUCT_TYPE_CODE_ID,10085131008770, TNA2.ATR_LEVEL)) cust1_investment_level
			         , MAX(DECODE(TFR2.ROLE_TYPE_CODE_ID||TNA2.ATR_PRODUCT_TYPE_CODE_ID,10085131008771, TNA2.ATR_LEVEL)) cust1_pension_level
			         , MAX(DECODE(TFR2.ROLE_TYPE_CODE_ID||TNA2.ATR_PRODUCT_TYPE_CODE_ID,10085141008768, TNA2.ATR_LEVEL)) cust2_protection_level
			         , MAX(DECODE(TFR2.ROLE_TYPE_CODE_ID||TNA2.ATR_PRODUCT_TYPE_CODE_ID,10085141008769, TNA2.ATR_LEVEL)) cust2_savings_level
			         , MAX(DECODE(TFR2.ROLE_TYPE_CODE_ID||TNA2.ATR_PRODUCT_TYPE_CODE_ID,10085141008770, TNA2.ATR_LEVEL)) cust2_investment_level
			         , MAX(DECODE(TFR2.ROLE_TYPE_CODE_ID||TNA2.ATR_PRODUCT_TYPE_CODE_ID,10085141008771, TNA2.ATR_LEVEL)) cust2_pension_level
			      from salex.t_na_atr@util.world tna2
			         , salex.t_ff_role@util.world tfr2
			      where TFR2.FACTFIND_INDIVIDUAL_ID = TNA2.FACTFIND_INDIVIDUAL_ID
			      group by TNA2.FACTFIND_ID
			  	 ) atr
			where TFF.STATUS_CODE_ID = 1008521
			and TFF.FACTFIND_ID = submissions.FACTFIND_ID
			and TFF.FACTFIND_ID = parties.FACTFIND_ID
			and TFF.FACTFIND_ID = expenditure.FACTFIND_ID
			and TFF.FACTFIND_ID = assets.FACTFIND_ID
			and TFF.FACTFIND_ID = liabilities.FACTFIND_ID
			and TFF.FACTFIND_ID = occben.FACTFIND_ID
			and TFF.FACTFIND_ID = protection.FACTFIND_ID(+)
			and TFF.FACTFIND_ID = savings.FACTFIND_ID(+)
			and TFF.FACTFIND_ID = pensions.FACTFIND_ID(+)
			and TFF.FACTFIND_ID = investments.FACTFIND_ID(+)
			and TFF.FACTFIND_ID = atr.FACTFIND_ID(+)
			and TFF.FACTFIND_ID = cust_ni.FACTFIND_ID(+)
			and TFF.FACTFIND_ID = cust_na.FACTFIND_ID(+)
			and TFF.FACTFIND_ID = b_and_c_premium.FACTFIND_ID(+)
			and TFF.FACTFIND_ID = needs.FACTFIND_ID(+)
			and TFF.FACTFIND_ID = sales.FACTFIND_ID(+);
 
Keywords: ORA-01000: maximum open cur…
Title
1 CURSOR Alternatives?
2 Stored Procedure Cursor
3 cursors in Db2
4 cursors in Sybase
5 Issue with Ref Cursor with CLOB - Or…
6 Use cursor to append row values?
 
Loading Advertisement...
 
[+][-]06.13.2008 at 08:14AM PDT, ID: 21779828

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.13.2008 at 08:20AM PDT, ID: 21779877

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.13.2008 at 08:25AM PDT, ID: 21779923

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.13.2008 at 08:28AM PDT, ID: 21779948

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.13.2008 at 08:41AM PDT, ID: 21780081

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.13.2008 at 09:07AM PDT, ID: 21780308

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.13.2008 at 09:53AM PDT, ID: 21780701

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.14.2008 at 12:19AM PDT, ID: 21784410

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.16.2008 at 12:57AM PDT, ID: 21791501

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.16.2008 at 01:28AM PDT, ID: 21791658

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.16.2008 at 01:35AM PDT, ID: 21791693

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.16.2008 at 03:17AM PDT, ID: 21792171

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.16.2008 at 03:19AM PDT, ID: 21792187

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.16.2008 at 03:26AM PDT, ID: 21792208

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.16.2008 at 03:39AM PDT, ID: 21792275

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Oracle Database, PL / SQL
Tags: pl/sql, ORA-01000: maximum open cursors exceeded
Sign Up Now!
Solution Provided By: Milleniumaire
Participating Experts: 5
Solution Grade: A
 
 
[+][-]06.16.2008 at 05:36AM PDT, ID: 21792942

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.16.2008 at 05:38AM PDT, ID: 21792955

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628