Home » SQL & PL/SQL » SQL & PL/SQL » Getting PROBE TIMEOUT Error....please help me out...It is urgent
Getting PROBE TIMEOUT Error....please help me out...It is urgent [message #201327] Fri, 03 November 2006 09:11 Go to next message
suranjita_hajra_7
Messages: 20
Registered: November 2006
Location: Pittsburgh, USA
Junior Member

Hello,

I'm running a stored procedure in oracle 10G that select data from one table and inserts the selected data into another table. The procedure populates for a short while and then I get the following messages:

1. probe: timeout Occurred
2. probe: Exception raised in the DBMS_DEBUG package

Why is this happening and what should I do to resolve the above issue?
Please help me out....This is really urgent...

Thanks a lot in advance....

Regards,
Suranjita
Re: Getting PROBE TIMEOUT Error....please help me out...It is urgent [message #201329 is a reply to message #201327] Fri, 03 November 2006 09:18 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Is the code too big to post easily?
Re: Getting PROBE TIMEOUT Error....please help me out...It is urgent [message #201332 is a reply to message #201329] Fri, 03 November 2006 09:28 Go to previous messageGo to next message
suranjita_hajra_7
Messages: 20
Registered: November 2006
Location: Pittsburgh, USA
Junior Member

Hello,

Here is my code, please suggest me......

Thanks a lot in advance....

Code which populates the table by selecting data from another table:


PROCEDURE scls_wk_rebuild (
p_pdegree NUMBER,
p_begin_date NUMBER,
p_end_date NUMBER
)
IS
cursor_handle INTEGER;
feedback INTEGER;
p_fiscal_week_end_date NUMBER;
to_table VARCHAR2 (300)
:= 'agg.sale_inv_org_ven_sclass_week';
from_table1 VARCHAR2 (300)
:= 'agg.sale_inv_org_ven_sclass_day';
--sql_stmt1 VARCHAR2 (30000);
--sql_stmt3 VARCHAR2 (30000);
--sql_stmt2 VARCHAR2 (5000);
--final_stmt VARCHAR2 (32760);
p_error_code NUMBER;
p_error_msg VARCHAR2 (255);
v_begin_date NUMBER := p_begin_date;
v_end_date NUMBER := p_end_date;
v_debug VARCHAR2 (1) := 'Y';
-- change this before implementing
BEGIN
/*************************

Override for testing in ddwu
************************/
v_begin_date := 20060402;
v_end_date := 20060408;
p_fiscal_week_end_date := 20061027;
/*************************

Override for testing in ddwu
************************/


/* Create a cursor to use for the dynamic SQL */
cursor_handle := DBMS_SQL.OPEN_CURSOR;

/* Construct the SQL statement and parse it in native mode. */


DBMS_SQL.PARSE
(cursor_handle,

'INSERT INTO '
|| to_table
|| ' (
organization_hierarchy_id
,product_hierarchy_id
-- ,fiscal_year_week
,vendor_id
,net_sales_rtl
,net_sales_units
,net_sales_cst
,receipt_units
,receipt_rtl
,receipt_cst
,merch_sale_units
,merch_sale_rtl
,merch_sale_cst
,pos_md_rtl
,md_units
,md_rtl
,return_units
,return_rtl
,rtv_units
,rtv_rtl
,rtv_cst
,shrink_units
,shrink_rtl
,shrink_cst
,inv_adj_units
,inv_adj_rtl
,inv_adj_cst
,emp_net_sales_rtl
,emp_net_sales_units
,emp_md_rtl
,emp_return_rtl
,emp_return_units
,reg_net_sales_rtl
,reg_net_sales_units
,reg_md_rtl
,reg_return_rtl
,reg_return_units
,clr_net_sales_rtl
,clr_net_sales_units
,clr_md_rtl
,clr_return_units
,clr_return_rtl
,promotion_rtl
,other_discount_net_sales
,other_discount_units
,vendor_freight_rtl
,emp_net_sales_cst
,reg_net_sales_cst
,clr_net_sales_cst
,date_added
,added_by
,date_last_modified
,last_modified_by
)

SELECT /*+ index(a), parallel(a,'
|| p_pdegree
|| ' )*/
organization_hierarchy_id
,product_hierarchy_id
--,p_fiscal_week_end_date
,vendor_id
,SUM(net_sales_rtl)net_sales_rtl
,SUM(net_sales_units)net_sales_units
,SUM(net_sales_cst)net_sales_cst
,SUM(receipt_units)receipt_units
,SUM(receipt_rtl)receipt_rtl
,SUM(receipt_cst)receipt_cst
,SUM(merch_sale_units)merch_sale_units
,SUM(merch_sale_rtl)merch_sale_rtl
,SUM(merch_sale_cst)merch_sale_cst
,SUM(pos_md_rtl)pos_md_rtl
,SUM(md_units)md_units
,SUM(md_rtl)md_rtl
,SUM(return_units)return_units
,SUM(return_rtl)return_rtl
,SUM(rtv_units)rtv_units
,SUM(rtv_rtl)rtv_rtl
,SUM(rtv_cst)rtv_cst
,SUM(shrink_units)shrink_units
,SUM(shrink_rtl)shrink_rtl
,SUM(shrink_cst)shrink_cst
,SUM(inv_adj_units)inv_adj_units
,SUM(inv_adj_rtl)inv_adj_rtl
,SUM(inv_adj_cst)inv_adj_cst
,SUM(emp_net_sales_rtl)emp_net_sales_rtl
,SUM(emp_net_sales_units)emp_net_sales_units
,SUM(emp_md_rtl)emp_md_rtl
,SUM(emp_return_rtl)emp_return_rtl
,SUM(emp_return_units)emp_return_units
,SUM(reg_net_sales_rtl)reg_net_sales_rtl
,SUM(reg_net_sales_units)reg_net_sales_units
,SUM(reg_md_rtl)reg_md_rtl
,SUM(reg_return_rtl)reg_return_rtl
,SUM(reg_return_units)reg_return_units
,SUM(clr_net_sales_rtl)clr_net_sales_rtl
,SUM(clr_net_sales_units)clr_net_sales_units
,SUM(clr_md_rtl)clr_md_rtl
,SUM(clr_return_units)clr_return_units
,SUM(clr_return_rtl)clr_return_rtl
,SUM(promotion_rtl)promotion_rtl
,SUM(other_discount_net_sales)other_discount_net_sales
,SUM(other_discount_units)other_discount_units
,SUM(vendor_freight_rtl)vendor_freight_rtl
,SUM(emp_net_sales_cst)emp_net_sales_cst
,SUM(reg_net_sales_cst)reg_net_sales_cst
,SUM(clr_net_sales_cst)clr_net_sales_cst
,SYSDATE
,SUBSTR(USER,1,Cool
,SYSDATE
,SUBSTR(USER,1,Cool
FROM '
|| from_table1
|| ' a WHERE a.date_id between '
|| v_begin_date
|| ' and '
|| v_end_date
|| ' GROUP BY organization_hierarchy_id
,product_hierarchy_id
,vendor_id',

DBMS_SQL.NATIVE);


/* Execute the DDL! */
feedback := DBMS_SQL.EXECUTE (cursor_handle);

DBMS_SQL.CLOSE_CURSOR (cursor_handle);
EXCEPTION
WHEN OTHERS
THEN
p_error_code := SQLCODE;
p_error_msg := SQLERRM;
DBMS_OUTPUT.put_line ('Error occured while loading' || SQLERRM);
RAISE;
COMMIT;
END scls_wk_rebuild;


Please suggest me regarding the following error which I get while running the above code:

1. probe: timeout Occurred
2. probe: Exception raised in the DBMS_DEBUG package

Why is this happening and what should I do to resolve the above issue?
Please help me out....This is really urgent...

Thanks,
Suranjita
Re: Getting PROBE TIMEOUT Error....please help me out...It is urgent [message #201337 is a reply to message #201332] Fri, 03 November 2006 09:55 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Is that the entire error message that you're getting?
No ORA-nnnnn?
No line number?

Where are you running this from? Do you get the same error if you run it from SQL*Plus?
Re: Getting PROBE TIMEOUT Error....please help me out...It is urgent [message #201338 is a reply to message #201337] Fri, 03 November 2006 10:02 Go to previous messageGo to next message
suranjita_hajra_7
Messages: 20
Registered: November 2006
Location: Pittsburgh, USA
Junior Member

I am running my procedure from TOAD 8.6.1, Procedure Editor.
I am not getting any ORA-nnn Error message.
When I execute the procedure on procedure editor on TOAD, it runs for sometime about 3 to 4mins then it pops up a dialog box saying : PROBE: TIMEOUT OCCURED. I click the OK button on the dialog box then it pops up another dialog box saying:
"probe: Exception raised in the DBMS_DEBUG package"
And the TOAD session hangs.
Please help me out to fix this issue. This is really urgent.

Thanks a lot in advance,
Suranjita

Re: Getting PROBE TIMEOUT Error....please help me out...It is urgent [message #201351 is a reply to message #201338] Fri, 03 November 2006 11:24 Go to previous messageGo to next message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
Of course it's urgent, just like every question you asked. Urgent, urgent!
Re: Getting PROBE TIMEOUT Error....please help me out...It is urgent [message #201362 is a reply to message #201351] Fri, 03 November 2006 13:27 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This probably won't help much, but I guess it also won't cost too much to try: I don't have your version of TOAD, but - somewhere in the Options - probably under "Procedure Editor - Debugging", there will be "Default to Compile with Debug". Do you have this checkbox checked? If so, try to uncheck it and run the procedure again.
Re: Getting PROBE TIMEOUT Error....please help me out...It is urgent [message #201421 is a reply to message #201362] Sat, 04 November 2006 02:46 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Why do you use dynamic sql for this? The tablenames are hardcoded anyway.
Re: Getting PROBE TIMEOUT Error....please help me out...It is urgent [message #201422 is a reply to message #201362] Sat, 04 November 2006 02:47 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
And, in addition to Littlefoots suggestion: If it doesn't work in TOAD, try it in sqlplus.
Re: Getting PROBE TIMEOUT Error....please help me out...It is urgent [message #201639 is a reply to message #201422] Mon, 06 November 2006 03:14 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
I read a couple of articles in the Metalink forums that related to this issue, and I think it's actually a TOAD error rather than an Oracle error.
Re: Getting PROBE TIMEOUT Error....please help me out...It is urgent [message #202655 is a reply to message #201639] Fri, 10 November 2006 12:57 Go to previous message
suranjita_hajra_7
Messages: 20
Registered: November 2006
Location: Pittsburgh, USA
Junior Member

Thanks for all help and support, My code ran in SQL Plus, it does not really run on TOAD...
Thanks all for the information
Previous Topic: Single quotes in a SQL query
Next Topic: Display 2 constant values as rows using one select statement!!
Goto Forum:
  


Current Time: Sat Dec 10 01:05:39 CST 2016

Total time taken to generate the page: 0.26782 seconds