Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [plsql-developer]

PL/SQL Developer is a development platform targeted at Oracle Database.

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

Over time more and more business logic and application logic moves into the Oracle Server, so that PL/SQL programming has become a significant part of the total development process.

PL/SQL Developer focuses on ease of use, code quality and productivity, key advantages during Oracle application development.

41 questions
7
votes
1 answer

Stop on error in PL/SQL developer or Oracle SQL Developer

At this time I am using TOAD to apply SQL*Plus scripts and there is an option to stop on the first error. After it I can fix the script and apply the remaining part. Due to license issues we can't use TOAD anymore and we have a choice between…
DaZdraPerMa
  • 71
  • 1
  • 1
  • 2
4
votes
4 answers

How to get return value from pl sql procedure and assign it to variable?

Code: execute x.procedurename(row.accc_no, row.bill_no, 0, null, row.total_balance, 'A',assgn_scen_site_cv, :assgn_scen_site_cv); Its my procedure. How to get return value from this proc and assign it to variable ?
Serdar
  • 41
  • 1
  • 1
  • 2
3
votes
1 answer

Make Oracle SQL Developer act like PL/SQL Developer

Is it possible to configure Oracle SQL Developer v 4.03 to automatically display tables while I'm typing in names like in PL\SQL Developer? Second question: How to make output grid look like PL/SQL Developer? Is it possible? Is it possible to…
breq
  • 145
  • 2
  • 8
3
votes
1 answer

How to figure out the latest version of a table in the 'recyclebin' section of PL-SQL developer

There are three tables with the same name Pantea in my recyclebin section of pl-sql developer and I don't know how to find the one that had been dropped the last (I mean the last version of the table). I can not restore all of them cause there can…
Pantea
  • 1,510
  • 5
  • 31
  • 59
2
votes
1 answer

Fill Database With Recursive Factorial Function

I want to calculate table's all of the rows's factorials value. And then i want to insert to each row's factorial value in table. so that i create table like as below: TABLE:FACTORIALS ------------------------------ | NUMBERS | FACTORIALS …
Mert Özoğul
  • 145
  • 1
  • 7
2
votes
1 answer

Could Not Be Accessed Value Of The For Loop Counter In PL/SQL

I try to learn PL/SQL for loops in tutorials. I learn flow of control in a for loops. (And i saw that it is same with most of the other programming languages) Here is the flow of control in a for loop: 1. The initial step is executed first, and…
Mert Özoğul
  • 145
  • 1
  • 7
1
vote
1 answer

How can I send an email when objects get invalidated?

I have couple stored procedures and a package. Whenever this stored procedure and package goes invalid, I need to send an email. How can I achieve this? Can you please give me an idea how this can be done.
user37143
  • 45
  • 1
  • 1
  • 5
1
vote
1 answer

First query running in PL/SQL Developer results the error

When I run first query in PL/SQL Developer I got the error: Dynamic Performance Tables not accessible, Automatic Statistics disabled for this session You can disable statistics in the preference menu, or obtain select privileges on the v$session,…
Narges SHadalouei
  • 21
  • 1
  • 1
  • 4
1
vote
0 answers

Error stopping profiler in plsql developer

I am checking on an performance issue and when I try to execute the time consuming query after turning on the profiler, after like a minute it gives the error "Error stopping profiler" and no data is available in the profiler report. Could someone…
lse23
  • 131
  • 2
1
vote
1 answer

Error (2.17): PLS-00201: The identifier 'DAYS_INTERVAL_TABLE' must be declared

I recently installed an Oracle 12c in Oracle Linux 7.6, it was previously in Windows. In the first database restored, some functions are with compilation errors. The query below informs you that there is a syntax error on line 2, but I can not…
Rafael Lima
  • 523
  • 3
  • 8
  • 19
1
vote
1 answer

PL/SQL Loop Returning One Result

I'm working with the following script: create or replace PROCEDURE a_proc is vi_get_emails varchar2(500); cursor get_emails is SELECT DISTINCT purchase_authorizer_api.get_userid('30', pagl.authorize_id) FROM purch_authorize_group_line pagl join…
krebshack
  • 111
  • 3
1
vote
2 answers

I'm going to wrap database trigger's source code, command properly run but source not encrypt

I'm going to wrap my source of database logon trigger. i run the command, "wrap iname='E:\block_tools_trigger_HR.sql' oname='E:\block_tools_trigger_HR.plb'". plb file created without any error but code not encrypted. Source code of trigger is given…
MOAZZAM ALI
  • 13
  • 4
1
vote
1 answer

Cannot list tables (views, packages etc) from Oracle 11 database using sql explorer, but can see them using PL/SQL Developer

I am connecting to oracle 11 DB. When I connect with PL/SQL, I can explore all the objects : However when accessing this same DB using Oracle SQL Developer, expanding the different objects results in empty list Any ideas why this might be?
Greg Bala
  • 1,025
  • 3
  • 10
  • 20
1
vote
1 answer

SQL80001 - incorrect syntax near ')'

In the below code (that I've inherited), I'm getting the message "SQL80001 - incorrect syntax near ')'", the error being on the third line from the bottom with the + sign. I've looked at THIS SO answer to similar issues, but that wasn't the issue…
Gregg Bursey
  • 119
  • 6
1
vote
3 answers

SQL developer licensing

SQL developer is free or do you require license for oracle database to use the sql or pl/sql developer? Also, Is it secure to connect to the oracle database since it connects to the db over a remote port right?
tesla747
  • 1,910
  • 10
  • 42
  • 77
1
2 3