Getting Error While Trying To Debug Procedure In Oracle SQL Developer

Apr 16, 2012

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.

View 2 Replies


ADVERTISEMENT

Client Tools :: Closed Connection Error After Procedure Debug In SQL Developer

Feb 25, 2011

Oracle Database: Oracle 11g Version: 11.1.0.6.0
Tool: Oracle SQL developer. Version : 1.1.3

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.

View 2 Replies View Related

Debug The Procedure In PLSQL Developer Tool?

Feb 18, 2009

I want to debug the procedure using PLSQL Developer tool?How to use the debug option in that tool?.

View 1 Replies View Related

Unable To Debug Procedure In 11g Database Using PL/SQL Developer

Mar 21, 2013

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?

View 1 Replies View Related

PL/SQL :: How To Debug In SQL Developer

Jul 14, 2013

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. 

View 1 Replies View Related

Client Tools :: PL/SQL Developer Debug Date / Time Variable

Oct 17, 2012

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.

View 4 Replies View Related

Connect To Oracle DB - Developer Error?

Apr 26, 2009

i've been trying to connect to the Oracle DB with Oracle SQL Developer.I get a message

State: Test Failed - IO Exception "The network adapter could not establish the connection"

When i go try tnsping 1521 It detects a connection by Oracle Database.And finally i get TNS-03505: Failed to resolve name

When i went into the "services.msc" and tryed to run the "OracleOraDb10g_home1TNSListener"

Got a message: "Error 3: The sytem could not find the specified path"

View 9 Replies View Related

Oracle 11g - Got Error On PL/SQL Developer / Could Not Initialize

Nov 25, 2011

i install the PL/SQL developer version 9.0.3.1641 on Windows-7 64 bit...i have Oracle 11g on this computer.when i run PL/SQL i got this error:

initialization error
could not initilize "c:\.......oci.dll"

make sure you have the 32 bits oracle client installed..what i need to install and from where to download ? (can i have link to download)

View 1 Replies View Related

Forms :: Error While Installing Oracle Developer Suite 10g?

Jul 1, 2011

While installing Dev Suite 10g i got the following error:[URL] What should i do? I specified another oracle home name, i have oracle database 11g installed too, and i'm installing dev suite 10g on another location.

View 3 Replies View Related

Forms :: Error While Installing Oracle Developer Suite 10g 10.1.2.0.2?

Oct 11, 2011

When I try to install "Oracle Developer Suite 10g 10.1.2.0.2" on Windows 7, I'm getting error , " Install has encountered an error while attempting to verify your virtual memory settings. verify that the sum of the initial sizes of the paging files is atleast 256 MB."

View 4 Replies View Related

Forms :: Remote Form Debug In Oracle 10g

May 12, 2010

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.

View 1 Replies View Related

SQL & PL/SQL :: Oracle - Getting Error While Writing Procedure?

May 3, 2012

I am Getting the error when writing the procedure. How to Solve this Error .

Error: PLS-00306: wrong number or types of arguments in call to 'PUT_LINE'

View 5 Replies View Related

Client Tools :: Creating Procedure Using SQL Developer?

Jan 23, 2012

I am trying to get my stored procedures together again after many years of working on MS SQL server. I'm alternating between using SQL-Plus and Oracle SQL Developer for Mac. In SQL Developer - which I like to use - I keep getting errors at the point where the END command for the package header occurs and the create command for the package body starts.

I've found that if I run the following in SQL-Plus I'm OK but if I try it from SQL Developer I get a compile error such as following or else an error telling me that it expects function, or pragma or something to that effect:

Error(8,1):PLS-00103:Encountered the symbol "/"

The code is as follows:
--------------------------------------
CREATE OR REPLACE PACKAGE MACR_SAMPLE_PROC_4 AS
PROCEDURE sampleproc_4(
pParam1 in integer,
pParam2 out varchar2);
END MACR_SAMPLE_PROC_4;

[code].....

View 9 Replies View Related

SQL & PL/SQL :: ORACLE Error 6550 In FDPSTP - Run Parallel All Procedure

Feb 15, 2012

I am creating a package. In case my package, i am want to run parallel all procedure(FillAndSend_IM1,FillAndSend_IM2,FillAndSend_IM3,FillAndSend_IM4 ) .

in package i using dbms_job.submit,

dbms_job.submit( l_job, 'FillAndSend_IM1;' );
dbms_job.submit( l_job, 'FillAndSend_IM2;' );
dbms_job.submit( l_job, 'FillAndSend_IM3;' );
dbms_job.submit( l_job, 'FillAndSend_IM4;' );

when procedure is runing , found error "ORACLE error 6550 in FDPSTP

Cause: FDPSTP failed due to ORA-06550: line 1, column 93:
PLS-00201: identifier 'FILLANDSEND_IM1' must be declared"

View 11 Replies View Related

Server Utilities :: Execution Of Oracle 11g Wrapped Procedure Gives Ora-00900 Error

Apr 4, 2013

I have a procedure which i wrapped using the oracle 11g wrap utility. If i execute the wrapped procedure using jdbc i am getting an error of 0RA-00900 invalid sql statement.

The procedure is having basic sql statements only.The same procedure if i wrap using Oracle 9i and execute using jdbc it works fine.Is there any change in Oracle 9i wrap utility and Oracle 11g wrap utility.

I tried even Oracle 10g wrap it is also not working fine.

View 4 Replies View Related

Error In PLSQL Developer

Dec 22, 2010

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.

View 3 Replies View Related

Getting Error When Try To Open PL / SQL Developer

Jul 3, 2012

i try to open PL/SQL Developer and i get this error:

Could not locate OCI dll
OracleHomeKey:SOFTWARE\ORACLE\KEY_OraOracle11g_home1
OracleHomeDir: d:\app\...................\product\11.1.0\client_1

what can be the problem ?

View 2 Replies View Related

Client Tools :: Getting Error While Connecting To DB In PL/SQL Developer

Dec 5, 2012

I am able to connect to the DB in TOAD , but I am not able to connect to the DB in PL/SQL developer.

PL/SQL developer

Version 8.0.1.1498
01.61091 - Unlimited user license
Windows 7 6.1 Build 7601 (Service Pack 1)
Oracle 11g

I am getting the below error

ORA-12154: TNS could not resolve the connect identifier specified

View 1 Replies View Related

Networking And Gateways :: ORA-12505 Error With SQL Developer

Jul 21, 2013

I installed oracle 11g successfully and was able to login with SQL plus.When I tried making a connection with the username and password via SQL developer I'm getting the ora-12505 error (picture is attached)

Printout of tnsname.ora:

# tnsnames.ora Network Configuration File: C:Oracle11gproduct11.2.0dbhome_1
etworkadmin nsnames.ora
# Generated by Oracle configuration tools.
ORACLE11G =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = oracle11g)
[code]....

getting sql developer connected with my oracle database?

View 13 Replies View Related

Client Tools :: Error When Trying To Connect Sybase Through SQL Developer

Nov 17, 2012

I am getting bellow error message when trying to connect Sybase through Sql developer: status:failure-test failed:IO Error:The network adapter

View 1 Replies View Related

Client Tools :: ORA-12545 Error In PL/SQL Developer In Windows 7

Jul 16, 2013

I am using Oracle 11g version, and i am using plsql developer 7.1.I am able to connect Oracle through sql*plus, But i am not able to connect Oracle through plsql developer from past few days, it is giving me error like: ora-12545 connect failed because target host does not exist...I recently installed oracle dev_suite 10g client first and then i installed oracle 11g server in windows 7. Both tns files are having identical entries.

Please find the tns entries below.

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = DEPANIGR-IN)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PLSExtProc)
[code]....

View 7 Replies View Related

SQL & PL/SQL :: How To Debug The Packages

Nov 2, 2011

Any ways for Debugging in PLSQL.

Ex:In a package or procedure i have thousands lines of Code how can i Debug.

View 1 Replies View Related

SQL & PL/SQL :: How To Debug A Code

Nov 2, 2011

how to debug PL/SQL code.

I mean if
procedure1 --calls---> procedure2
procedure2 --calls---> procedure3
procedure3 --calls---> procedure4

If procedure1 is my main procedure how do we know in procedure there is an unhandled exception or bug.

View 2 Replies View Related

SQL & PL/SQL :: How To Debug Package

Apr 20, 2013

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.

View 6 Replies View Related

Forms :: Run 10g In Mode Debug?

Jan 5, 2012

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?

View 2 Replies View Related

Forms :: Debug - Values Stored During Execution?

Aug 25, 2010

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.

View 1 Replies View Related

Export/Import/SQL Loader :: Error During Data Pump Import With Developer

Sep 17, 2012

I try to transfer data from one database to another one through data pump via SQL Developer (data amount is quite important) exporting several tables. Tables export is doing fine, but I encounter the following error when I import the file (I try data only and data + DDL).

"Exception: ORA-39001: argument value invalid dbms_datapump.get_status(64...=
ORA-39001: argument value invalid
ORA-39000: ....
ORA-31619: ...

The file is in the right place, data pump folder of the new database. User is the same on both base, database version are similar.

View 4 Replies View Related

Forms :: 10g - Debug And Check Values Of Defined Variables

Sep 22, 2010

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.

View 1 Replies View Related

Oracle Developer 10g Installation

Feb 12, 2011

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.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = Oracle8)
(SID_NAME = ORCL)
[code].......

tnsnames.ora has following words:

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = HOSTNAME)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
)
)

View 2 Replies View Related

Client Tools :: Debug Function Which Returns Table Of Records?

Apr 24, 2012

I want to debug a function which returns the table of records. When I try to add the parameters and run the debug it gives the error as

PLS-00653: aggregate/table functions are not allowed in PL/SQL scope

if there is any way to debug the function which returns table of records.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved