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
4
votes
1 answer

pragma autonomous_transaction in a trigger

I have written a trigger on one table which deletes data from other table upon a condition. The trigger has pragma autonomous_transaction, and trigger works as intended. However, I do wonder if there can be any problems in future, say if data is…
Jaanna
  • 1,620
  • 9
  • 26
  • 46
4
votes
2 answers

Query execution time in PL/SQL Developer

I'm running queries in PL/SQL Developer. How to find out the running time of sql query in PL/SQL. I am querying specific tables. Like select * from table_name where customer_id=1; select * from movie_table where movie_id=8; While i am using…
careem
  • 57
  • 1
  • 1
  • 9
4
votes
2 answers

How to print SYS_REFCURSOR with PLSQLDeveloper window?

In the below query how to get IO_CURSOR values in PL/SQL's "SQL Window" DECLARE SOME_VAR_1 VARCHAR2(20); SOME_VAR_2 VARCHAR2(20); SOME_VAR_3 DECIMAL; IO_CURSOR SYS_REFCURSOR; BEGIN SOME_VAR_1 := 'test1'; SOME_VAR_2 := 'test2'; …
Jeevan Bhatt
  • 5,881
  • 18
  • 54
  • 82
4
votes
6 answers

oracle pl/sql bug: can't put_line more than 2000 characters

Has anyone else noticed this phenomenon where dbms_output.put_line is unable to print more than 2000 characters at a time? Script is: set serveroutput on size 100000; declare big_str varchar2(2009); begin for i in 1..2009 loop …
FrustratedWithFormsDesigner
  • 26,726
  • 31
  • 139
  • 202
4
votes
1 answer

Oracle package debug doesn't stop on breakpoint

I have the following structure: A package PCK_LANCAMENTOSERVICO within a procedure called P_Integra. This procedure calls another procedure in another package PCK_LANCAMENTO called P_BeforeLancamento The procedure P_BeforeLancamento calls another…
André Scaravelli
  • 251
  • 1
  • 4
  • 9
4
votes
1 answer

Getting First Occurred value from the XML using oracle parser

I am not expert of Oracle, but as per requirements I am using Oracle Parser for Parsing Xml. For listed below xml i.e. …
IConfused
  • 714
  • 2
  • 8
  • 20
4
votes
9 answers

Reading clob line by line with pl\sql

In my project i use oracle as primary database and i've faced a problem with parsing clob. So suppose we have a clob with value aaaaaa cccccc bbbbbb And it's stored in table test ... I need to write plsql procedure to get this clob and…
ilya.stmn
  • 1,604
  • 5
  • 23
  • 41
4
votes
3 answers

PLSQL Trigger to update field value in another table

I am quite new to triggers so obviously I am doing something wrong somewhere. I am working on a report table which will get the data from original tables. For the sake of simplicity, let's say that there is one table and then there is one reporting…
Jaanna
  • 1,620
  • 9
  • 26
  • 46
4
votes
6 answers

(+) function in PLSQL

I'm now dealing with PLSQL developer, which is my very first time. And I find this kind of query select * from tableA, tableB where tableA.field1 = tableB.field1(+) I'm wondering the function of the (+) in the query. Could you guys be so kind to…
Andha
  • 907
  • 2
  • 11
  • 22
3
votes
1 answer

Debugging Oracle Triggers using PL\SQL Developer 7.0.2?

I am able to debug the procedures and functions in PL\SQL Developer but when i set break points for Trigger its not taking them as a valid break points. Can we debug code in triggers using pl\sql developer.
Maddy
  • 3,726
  • 9
  • 41
  • 55
3
votes
1 answer

dbms_output.put_line in PLSQL Developer fails with ORA-06502 for strings longer than 32512 chars

This script fails in PLSQL Developer version 14.0.0.1961 (error ORA-06502: PL/SQL: numeric or value error: character string buffer too small): declare v varchar2(32767) := rpad('x',32513,'x'); begin dbms_output.enable(null); …
Tomáš Záluský
  • 10,735
  • 2
  • 36
  • 64
3
votes
3 answers

capture sql developer script output in java

As part of my java application, I have to create oracle packages from java code. Sometimes, the package code might have issues and compilation might fail. However, I am unable to capture simple failures from java. So, i have to compile > 350 oracle…
Just Praveen
  • 63
  • 6
3
votes
1 answer

Inserting Row Number based on existing value in the table

I have a requirement that I need to insert row number in a table based on value already present in the table. For example, the max row_nbr record in the current table is something like this: +----------+----------+------------+---------+ | FST_NAME…
Abhinav Dhiman
  • 745
  • 3
  • 17
3
votes
1 answer

PL/SQL package type vs schema type

What I'm trying to do is the following: create or replace package MyPackage as type string_list_t is table of varchar2(32767); function GetPrimaryKeys ( p_table_name varchar2, p_owner varchar2 ) return string_list_t; end…
vines
  • 5,160
  • 1
  • 27
  • 49
3
votes
2 answers

How to rename scheduler job Oracle

I would like rename scheduler job in Oracle, is it possible? dba_scheduler_jobs(owner = "db", name = "my_job") => dba_scheduler_jobs(owner = "db", name = "my_own_job"); Thanks for answers.
Hadraigh
  • 31
  • 1
  • 2
1 2 3
…
99 100