Recent content by P J S

Hi, While I write a cursor with large number of columns in select clause, and apply beautifier, it puts one column per line whereas my requirement is to put multiple columns per line in select statement. so that code does not become lengthy. Can you please help me to how to relevant settings...

Hi, I recompiled it with debug info using 'Add debug information'. It is now working fine.. Thanks for your help. Regards, --P J S

Hi, In a test window, when a try to debug some procedure in a package, it is not opening that procedure there. However it is opening other procedures and triggers that are getting called from that procedure... I need to see execution of that procedure also. Did I do some wrong setting that is...

Hi, Thanks for your help. It worked. I have successfully debugged at perticular iteration of loop. Thanks and regards, --P J S

Thanks a lot for your reply... Will try this.. --P J S

Hi, I am using PLSQL developer version 7.1.5.1398. I am trying to debug procedure wherein a loop is having 2048 iterations. I want to set up a breakpoint for a perticular iteration. Can it be possible ? Looking forward for your support. Thanks and regards, --P J S

Hi, I am using oracle 10g. I have 2 tables 1. costomer_complaints table customer_id complaint_id engineer_id 1001 5001 15 1002 5002 15 1003 5003 15 1004 5004 15 1005 5005 15 1006 5006 15 1007 5007 15 1008 5008 15 1009 5009 15 1010 5010 15 2. SELECT jr_engineer_id FROM TIM_emp where...

Its done :) I used returning into clause.. Thanks.. -P J S

Hi, I am inserting a new record into a 'master' table. Primary key is generated using a sequence. Now using that newly inserted primary key value, I need to insert a new record in child table. These 2 insert queries need to run at the time of deployment. My question is, how shall I store that...