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
5
votes
3 answers

How to use Oracle global temporary table?

I am attempting to use an Oracle global temporary table without physically creating a table in the database. The following code is not working. Can someone please explain the proper way to use global temporary tables? declare global temporary…
Deep in Development
  • 497
  • 2
  • 8
  • 24
5
votes
2 answers

Can debug but Can Not inspect or watch variables in a huge PlSql package in Oracle

I've got a "huge" Pl/Sql package (about 1.4 Mb, about 30.000 lines) running in Oracle database 10.2.0.4.0 - 64bit over Solaris. I can debug it step by step (package is marked as debuggin) but my problem is when I try to watch or inspect any…
Alex
  • 51
  • 1
  • 3
5
votes
3 answers

How to create cursor inside procedure body in plsql

I want create cursor inside procedure body dynamically also i have to use for loop instead of below code. i did the dynamic cursor but i cannot use the for loop. PROCEDURE myprocedure AS LV_TEST_CUR SYS_REFCURSOR; LV_QUERY VARCHAR2(200); …
satheesh
  • 187
  • 1
  • 4
  • 14
5
votes
7 answers

Timezone conversion in PLSQL

I need to convert the sysdate and time to a particular timezone like EST. I can't assume my current time zone. How to convert this in plsql? Please help me.
Suvonkar
  • 2,440
  • 12
  • 34
  • 44
4
votes
2 answers

Cannot export table from PL/SQL developer having a column datatype as CLOB

I need to export table having a column datatype as clob. I need to have inserts scripts for that table. But I get following error when I try to export the table from PL/SQL developer Table XYZ contains one or more CLOB columns. Cannot export in…
user1233906
  • 41
  • 1
  • 2
4
votes
3 answers

Error when trying to log in: ORA-12154

I am using Oracle 10g and PL/SQL Developer for the development. I have already tested from Net Manager that the database can be connected to, but when I tried to connect with PL/SQL Developer there was problem that I do not understand: ORA-12154:…
Nore
  • 111
  • 2
  • 4
  • 20
4
votes
2 answers

PL/SQL send email with attachment?

we have a table with files saved as BLOB I write a code that email these files as an attachment! everything works fine so far, but the files (EXCEL,PDF, ... what ever) are not readable by the programs, only text files and excel will open but after…
Data-Base
  • 8,418
  • 36
  • 74
  • 98
4
votes
2 answers

PLSQL turn clob containing json into table

Is there a way to turn a clob containing JSON Object into table for example I have a clob containing [{"a":"1","b":"1"; "a":"2", "b":"2"; "a":"2","b":"2"}] I want to turn this into a table to join it with other tables in my database. is there a way…
Kyujiin
  • 99
  • 2
  • 10
4
votes
1 answer

Oracle PL/SQL get server's IP v4?

How can I get the IP v4 Of the server by using PL/SQL ? UTL_INADDR.GET_HOST_ADDRESS gives me IPv6, while I need IPv4 what I did I disabled the IPv6 on the sever, still it's bringing me the the IPv6 of the "Tunnel adapter Teredo Tunneling…
Data-Base
  • 8,418
  • 36
  • 74
  • 98
4
votes
1 answer

Oracle & PL/SQL Developer - Access predicates and Filter predicates no longer shown

I'm using Allround Automation PL/SQL Developer with Oracle 10g, and today I've noticed that explain plans no longer display anything for Access Predicates or Filter Predicates. The only thing that's changed (that I know of) is that yesterday I tried…
FrustratedWithFormsDesigner
  • 26,726
  • 31
  • 139
  • 202
4
votes
1 answer

why i'm not getting error? how does database understand relevant column in nested subquery?

Here is the scenario: I have two tables department and employee. when i'm selecting a column from a table which doesn't exist in that table, it's throws error as expected. However, when i'm using subquery and again selecting the same column from the…
Channa
  • 742
  • 17
  • 28
4
votes
1 answer

get_detailed_sqlerrm syntax on PL/SQL

I'm trying to debug an "HTTP Request Failed" error on PL/SQL for a function trying to consume a SOAP web service. The suggestion is to use get_detailed_sqlerrm to get the details of the error message, but when I try to run the suggested query, it…
Meloku
  • 45
  • 1
  • 2
  • 9
4
votes
1 answer

Setting default column values for Sql Developer Import

I've the following Log table in my database: FROM_PARTY_ID VARCHAR2(15 CHAR) Not Null TO_PARTY_ID VARCHAR2(15 CHAR) Not Null CREATED_DT DATE Not Null UPDATED_DT DATE Null NO_OF_TRIES NUMBER(3,0) Null APPLICATION_ID VARCHAR2(15 CHAR) …
user1547554
  • 441
  • 2
  • 8
  • 16
4
votes
1 answer

How to check activity log of Oracle SQL Developer

I want to monitor Activity Logs on Oracle SQL Developer Tool, using F8 key i am getting SQL history. I want user session-wise data like who (user) have executed which query or any operation from GUI.
Code Hungry
  • 3,930
  • 22
  • 67
  • 95
4
votes
3 answers

How to generate database diagram or ER diagram automatically with pl/sql developer?

How to generate database diagram or ER diagram automatically with pl/sql developer? I'm asking about pl/sql developer not sql developer.
user3405742
  • 41
  • 1
  • 2
1 2 3
…
99 100