I am not able to debug PL/SQL and i have following error..how I can enable privileges and I want to know the steps of debugging. Connecting to the database My_connection.
Executing PL/SQL: ALTER SESSION SET PLSQL_DEBUG=TRUEExecuting PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCPORA-01031: insufficient privilegesORA-06512: at "SYS.DBMS_DEBUG_JDWP", line 68ORA-06512: at line 1This session requires DEBUG CONNECT SESSION and DEBUG ANY PROCEDURE user privileges.Process exited.Disconnecting from the database My_connection.
I tried to debug the procedure in Oracle SQL Developer and got the below error,
Connecting to the database TEST. Executing PL/SQL: ALTER SESSION SET PLSQL_DEBUG=TRUE Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( '****', '4000' ) ORA-30683: failure establishing connection to debugger ORA-12535: TNS:operation timed out ORA-06512: at "SYS.DBMS_DEBUG_JDWP", line 68 ORA-06512: at line 1 Process exited. Disconnecting from the database TEST.
Here,
TEST is my database name, **** is IP address of my local machine 4000 is the port number, also I have set the debug port range as 4000 - 4999 in SQL DEVELOPER. firewall is not enabled in my machine.
We have recently migrated our database from 10.2.0.4 to 11.2.0.2. We were able to debug procedures using PL/SQL Developer earlier but after 11g migration we are not able to debug the same procedure in 11g database.
Is it that we require 11g PL / SQL developer with 11g client installed to debug?
I have a little problem when debugging in pl/sql developer. All date variables are always displayed DD-MON-RR. I already changed the values for Date and Time to YYYY-MM-DD HH24:MI:SS in
Tools => Preferences => User Interface / NLS Options.
But when I start debugging and watch a variable I still get eg. 17-OCT-12 without the time. I already restarted pl/sql developer. No change.
Problem: After completing debug of procedure from SQL Developer, whenever I try to compile that procedure or execute any query from the SQL worksheet, I get the closed connection error message. However I can debug that procedure for any number of times. Any other activity for that database connection gives closed connection error.
I have written a package including 13 procedures to insert data into a temp table but i am getting duplicate rows in dat table how to track from which procedure i am getting duplicate rows.
step 1 : procedures are inserting data using some joins into a temp table. step 2: from temp table data will get stored into a target table where if the data already exist it will update the target table else will insert the data.(its a procedure where i used merge).
as i have duplicate data on temp table i am not able to update data on target table.
I want to run form 10g in mode debug, however when i set break point in code and press shift+ F9 ( or run Debug by click icon on Form 10) then Form still run but not run in mode debug. Now i want to run form 10g in mode debug, how do i do?
I have a set of code being perform in the package body of a program unit I want to debug step by step and see what values are being stored during executing or running the form
/* Without HP and deposit, Down Payment(GST) = Total(GST) */ if nvl(v_deposit, 0) = 0 and nvl(v_loan_amt, 0) = 0 then v_gst_fr_dps := 0; v_gst_hp := 0; v_gst_bal_pay := v_total_gst; [code].........
Like in the above example I want to see the value in v_gst_fr_dps,v_gst_hp,v_gst_bal_pay etc when executing and display in the screen.
I am trying to debug a remote form ( on AS) in Oracle forms developer 10g . I had done everything as told and attached the port name and number to my local form builder, but debugger window doesn't popup at the time of break point. Also, i don't have any firewall installed on my application server.
I am currently working in form 10g and i m newbie to that technology...I want to debug my form and also check step step by values of variables which i defined.
I have upgraded my Operating Syatem from Vista to Win7. I have SQL nav version but is not supported on Win7. So I have installed PLSQL developer. When I try to connect its giving the error connection not open. But when I tried the same credentials with SQLPLUS it's working fine.
I have installed Developer 10 suite and 6i on same machine, developer 6i run time works properly but when i open URL with "?config=icc" it says form generated in previous version of forms builder, i have already compile called form (configure in default.env and formsweb.cfg) in forms builder 10g.
I have installed oracle form developer10g. without installing the oracle database. Oracle developer 10g can run independently.
I get the Error TNS: Protocol Adapter Error
My listener has the following: # listener.ora Network Configuration File: D:DevSuiteHome_2NETWORKADMINlistener.ora # Generated by Oracle configuration tools.
I work with several tables at a time in SQL Developer and I find myself having to reopen and freeze every table everytime I start the application. Is there a way to save all those frozen views for next time?
I am using oracle developer 10g R2. Now i would like to create a java(jar) function or any other type then would like to add this jar file into my oracle form with a button and when i run this and click on this button then display the message from java function.
How I can install and use Oracle Developer 6i and Oracle Developer Suite 10g on the computer? It needed registry edition or is there any "official" way?