Stack Overflow
Stack Overflow

Questions tagged [plsqldeveloper]

PL/SQL Developer is an Integrated Development Environment by Allround Automations that is specifically targeted at the development of stored program units for Oracle Databases.

PL/SQL Developer is an Integrated Development Environment by Allround Automations that is specifically targeted at the development of stored program units for Oracle Databases.

Home page: http://www.allroundautomations.com/plsqldev.html

PL/SQL Developer should not be confused with Oracle's SQL Developer: http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html

1591 questions
2
votes
1 answer

Remote debug PL/SQL packages

Let's say I have a running java web application, where I am trying to save some data, using JDBC that is calling a PL/SQL package in the database. In the java code, the execute() function has been called, the data to be saved has been sent to the…
Oliver
  • 1,218
  • 1
  • 17
  • 21
2
votes
0 answers

How to execute sybase stored procedure in SQL Developer with input and out put params?

I am working on a new Database in Sybase. I am not sure how to run sybase stored procedures from SQL Developer. I have used SQL developer before with Oracle. my stored procedure look like this. IT is working stored procedure. create proc…
VSRSarma Chinta
  • 23
  • 6
2
votes
1 answer

How to populate all column names in PL/SQL developer?

In SQL developer if I type below statement and press ctrl + space, the list of all column names are displayed. select * from mytable where How to achieve the same in PL/SQL developer version 11.1?
user2488578
  • 896
  • 4
  • 21
  • 40
2
votes
1 answer

UTF-8 characters in Oracle

I want to insert UTF-8 characters in Oracle 12 database using INSERT statement. I'm using PL/SQL Developer Tool (version 8). When I run this INSERT statement INSERT INTO my_table (my_column) VALUES ('ტექსტი'); and then run the SELECT statement…
JiboOne
  • 1,438
  • 4
  • 22
  • 55
2
votes
1 answer

How to call an Oracle function of refcursor return type using sqlalchemy and python

Function is given below: CREATE or replace function get_data(data_key integer) return sys_refcursor is result1 sys_refcursor; BEGIN open result1 for 'Select DISTINCT COL1 FROM REF_TABLE where DATA_KEY='||data_key; return…
Vinay Ranjan
  • 294
  • 3
  • 14
2
votes
1 answer

need to query XML for value in Oracle 11g

I have a table called parts with an XMLType column called RunList_XML The XML has several Unit tags example 420 10 0 I want to query to get back a list of all parts…
China Syndrome
  • 953
  • 12
  • 24
2
votes
1 answer

How to list the all the trace events enabled in the oracle database

please suggest the sql query to list the all active trace events in the oracle database. More ora trace log files are getting generated for the particular database . This might be the cause of trace was enabled for some objects or sessions or sql…
sasikumar
  • 73
  • 1
  • 9
2
votes
1 answer

oracle PL/SQL how to calculate range ip for IPv6 cidr

ex.IPv6 address with CIDR: 2620:0:2d0:200::7/32 out put Start Range: 2620:0:0:0:0:0:0:0 End Range: 2620:0:ffff:ffff:ffff:ffff:ffff:ffff how to calculate with PL/SQL ?
Siritorn Pulsrikan
  • 35
  • 4
2
votes
2 answers

Oracle SQL Developer - Help for debugging

I am trying to debug a package with in the SQL Developer. The method that i am trying to debug takes 2 parameters PROCEDURE procedure_name (dblink IN CHAR, bDebug IN BOOLEAN DEFAULT FALSE) When i click on "Debug" icon, it asks for inputs that i…
x.509
  • 2,205
  • 10
  • 44
  • 58
2
votes
1 answer

Regarding sql reporting

i am doing a spool of sql select output. i have the below sql settings SET FEEDBACK OFF SET HEADING OFF SET LINESIZE 800 SET PAGESIZE 50000 SET TRIMSPOOL ON SET TERMOUT OFF SET ECHO…
Arav
  • 4,957
  • 23
  • 77
  • 123
2
votes
2 answers

Find occurrences of a text and replace them with a new word in PL/SQL Developer?

We have a Oracle database and we are using PL/SQL Developer for editor. There is an old javascript function which have been used thousands of times in different procedures. We need to replace the name of that function. Is there a way in PL/SQL…
misman
  • 1,347
  • 3
  • 21
  • 39
2
votes
3 answers

How to get full value of clob while debugging PL SQL script on sql developer

I'm going in debug in a procedure PL/SQL on SQL Developer that make a big query and store it in a CLOB. When i take the value of that CLOB, the value is truncated. Can anyone know any method to take a full value of CLOB in debug mode?
Milaci
  • 515
  • 2
  • 7
  • 24
2
votes
1 answer

How to find dependencies inside an oracle package?

My question is how to find inside oracle package dependencies by SQL query or any other internal/external tool. Is it even possible or should I just go trough the code and find out myself? Example case: I have a package which contains 4 procedures…
massko
  • 589
  • 1
  • 7
  • 22
2
votes
4 answers

PL/SQL Developer statements sometimes do not commit or "stick"

I apologize if this is too vague, but it is a random issue that occurs with many types of statements. Google and Stack Overflow searches have failed me. Here is what I am experiencing, I hope that someone out there has seen or at least heard of this…
MKowalski
  • 37
  • 2
  • 7
2
votes
1 answer

allround automations pl/sql developer on windows 7 - TNS over IP connect to remote db

I am really having very hard time making PL/SQL developer PL/SQL Developer work on my windows 7 64-bit OS. I have Oracle 10g standard edition installed already. I tried with PL/SQL developer version 7 and 8 with no luck. Do anyone tried doing it?.…
A_Var
  • 1,056
  • 1
  • 13
  • 23
1 2 3
…
99 100