Home » SQL & PL/SQL » SQL & PL/SQL » Issue while using Bulk Collect
Issue while using Bulk Collect [message #323056] Tue, 27 May 2008 03:48 Go to next message
raja23
Messages: 4
Registered: May 2008
Junior Member
Hi All,

I have a procedure in which i am using three cursors,three table types,three bulk collects,with limit 1000.
The procedure is with 10 optional parameters,when i pass with parameter any customer_id or site_id,i get the data good,but when i pass only a single parameter with date,its showing error out.
The procedure is getting error out for a single parameter,i hope its getting due to huge records which the bulk collect cannot perform to insert into the table.
When i tried the same through back end in pl/sql dev,it showed error after a long time saying some not enough space available.

Can any one please give me suggestions how to over come this type of issue.


Thanks a lot in Advance
Re: Issue while using Bulk Collect [message #323059 is a reply to message #323056] Tue, 27 May 2008 03:55 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Can any one please give me suggestions how to over come this type of issue.

Without any code, any error, any version, my suggestion is to post something useful for us to help you.

Regards
Michel
Re: Issue while using Bulk Collect [message #323066 is a reply to message #323059] Tue, 27 May 2008 04:10 Go to previous messageGo to next message
raja23
Messages: 4
Registered: May 2008
Junior Member
Hi Michel,

Please find the attched document.And let me know if u need any more information



Regards,
Raja
  • Attachment: pkg1.txt
    (Size: 35.67KB, Downloaded 327 times)
Re: Issue while using Bulk Collect [message #323072 is a reply to message #323066] Tue, 27 May 2008 04:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Sorry, too long package to analyze and we still don't have/see the error.
Copy and paste an execution, with and without error.

Regards
Michel
Re: Issue while using Bulk Collect [message #323073 is a reply to message #323066] Tue, 27 May 2008 04:23 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
How about telling us the error you got.
That might help.
Re: Issue while using Bulk Collect [message #323102 is a reply to message #323073] Tue, 27 May 2008 05:21 Go to previous messageGo to next message
raja23
Messages: 4
Registered: May 2008
Junior Member
Hi JRow,

I am unable to identify the problem,because when i am running the package with customer_number or site_id,its getting the output.
Whereas if i pass only report_code or business_segment with date,i am getting error output from front end.
When i tried from back end,its saying space not enough.


Please let me know if any more information u need,

waiting for your reply,


Regards,
Raja
Re: Issue while using Bulk Collect [message #323103 is a reply to message #323102] Tue, 27 May 2008 05:29 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Tue, 27 May 2008 11:22
Sorry, too long package to analyze and we still don't have/see the error.
Copy and paste an execution, with and without error.

Regards
Michel


Re: Issue while using Bulk Collect [message #323119 is a reply to message #323103] Tue, 27 May 2008 06:14 Go to previous messageGo to next message
raja23
Messages: 4
Registered: May 2008
Junior Member
Hi Michel,

Just go through the GEN_REPORT_DATA,this is the Procedure which is getting error,when ececuting from front end,the other procedure is just send output to Email_id
Re: Issue while using Bulk Collect [message #323126 is a reply to message #323119] Tue, 27 May 2008 06:44 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Why do you expect us to wade through a 35 kB textfile, searching for some vague thing, if you can't even deliver when asked to tell us what error you get and to show us exactly what you did by providing a copy-paste of a sql-plus session?
Previous Topic: unable to union two tables?
Next Topic: Issue: Different Date formats in the same cloumn in a table
Goto Forum:
  


Current Time: Sat Dec 03 16:20:13 CST 2016

Total time taken to generate the page: 0.07170 seconds