Recent content by usertale

Where do I find the Preferences you are refering to? thank u.

I have compiled my code and tested it with the debugger. Now I want to deploy - how do you remove the debug information? I still see the 'Add Debug Information' checked when I right-click on the object ... I want to remove this ... thank u

I have PL/SQL Developer 7.1.5 and I can not find the tool 'Compare Soure'. Please don't tell me it has been removed? Where is it?

BEGIN DBMS_OUTPUT.ENABLE(1000000); DBMS_OUTPUT.PUT_LINE(Program started at ' || TO_CHAR(SYSDATE, 'DD-MON-YY HH:MI:SS')); run_proc(1); END; / The above code in a test script causes the debugger to hang, waiting on an (internal) PIPE call. Is this a bug??

Version 7.1.4.1390

Find Database Objects 'BREAK' button does not work too well....hasv to kill my PSD session to get it killed...is this a bug?? thank u

Addendum: Ran some DBA queries and looks like my session is waiting on a dbms-pipe message, but the message isn

I am getting a debugger issue in PL/SQL Developer

An example would be to do something like the followning job PL/SQL: declare v_job_status VARCHAR2(1) := 'N'; begin -- check job status select broken into v_job_status from dba_jobs where job = (select /*+ RULE */ job from dba_jobs_running where sid = userenv('SID'))...

Never got any feedback from the following circa 1/8/08: ========================================= You mentioned "It is always a good idea for the programmer to check inside the job itself (for instance at the beginning of a loop) whether the job is broken. If the job is broken, the program must...

You mentioned "It is always a good idea for the programmer to check inside the job itself (for instance at the beginning of a loop) whether the job is broken. If the job is broken, the program must be exited. In this way the code will eventually stop when the code inside the job finds out that...

Actually, if you check the 'Broken' checkbox and hit the 'Apply' button ,the job will stop. Reverse the process and the job will start rerunning. Thx.

Hello... How do I stop a Oracle Job in PL/SQL Dev? And then how do I restart the job? Can I just use the 'broken' check box? thx.