Questions tagged [plsql-developer]

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

Filter by
Sorted by
Tagged with
0
votes
0answers
19 views

'go to symbol' in Allround Automation PL/SQL Developer?

I really like using my PC just by keyboard and any time I have to use a mouse is a real pain for me. I really like 'go to symbol' feature in VS Code or Sublime Text, so I can navigate through any ...
0
votes
1answer
176 views

how to install PL/SQL Developer on centos

Can we install and run PL/SQL Developer on CentOS 7 server? I couldn't find installation documents anywhere. If the installation is possible can someone guide me on this.
0
votes
1answer
31 views

Access tables from multiple schemas

I have two schemes with multiple tables. The queries in packages heavily reference schema names. Is it possible to remove schema names from the queries and oracle to identify the tables based on roles ...
1
vote
1answer
210 views

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 ...
1
vote
1answer
45 views

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....
1
vote
2answers
61 views

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 ...
1
vote
1answer
782 views

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 ...
0
votes
1answer
2k views

ORA-03135 connection lost contact

First i connect to oracle remotely, then open pl/sqldeveloper create one table. Then i am trying to import csv file to PL/sql developer. Importing process starts normally, but every day midnight we ...
0
votes
3answers
159 views

Connect to oracle 11 on a corporate network via oracle developer 17

Sorry for this absolute oracle noob question: I am in an environment that uses integrated / active directory authentication, for developer to access the oracle databases via an old version 9 PL/SQL ...
0
votes
2answers
773 views

PLS-00306 dbms_scheduler.create_job

I'm not an expert about DBMS_SCHEDULER.CREATE_JOB and i've been asked to create a job. When i run it i get these errors: ORA-06550: line2,column 2 PLS-00306: wrong number or types of arguments in ...
0
votes
1answer
94 views

How can I manage PL/SQL package source at the method level?

In our ERP application suite, we have a very small number of PL/SQL packages that are large and monolithic in nature, containing a wide assortment of functionality. (This is because each package ...
0
votes
1answer
748 views

Invalid directory path error while connecting to database

I am using oracle 11g and using sqldeveloper to run/edit queries. My table is: ID FIRST_NAME LAST_NAME MAJOR CURRENT_CREDITS 10008 A Dd Computer ...
0
votes
1answer
363 views

PLSQL: Package stored procedure cannot call exe imediate statement

I'm working with oracle 11g R2. Issue: I am unable to preform dynamic SQL in SchemaB package against SchemaA tables. SchemaB is being called by the owner of SchemaB. Background: I have a package/...
0
votes
1answer
656 views

How to run a query in PL/SQL with Serializable transaction isolation

I want to run this SQL in Oracle 11g: declare a number; begin select count(*) into a from item w where w.Item_num='MOH601' ; dbms_output.put_line(a); end ; How to run this query with ...
3
votes
2answers
44k views

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 ...
2
votes
1answer
316 views

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 ---------------...
2
votes
1answer
399 views

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 ...
0
votes
2answers
677 views

ORA-01422 Error Occurred When I Call Procedure with Number Parameter

I want to write PL/SQL Procedure that updates salary which is less than 2000. I wrote this procedure.And when i call it with integer id 'ORA-01422: exact fetch returns more than requested number of ...
0
votes
0answers
53 views

Create connections in sqldeveloper. 12505 error

I have oracle 12c installed in my ubuntu 15.10, I can run sqlplus with sqlplus / as sysdba and run it in a CLI. But I want to be able to use it with sqldeveloper. cat $ORACLE_HOME/network/admin/...
1
vote
1answer
1k views

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 ...
0
votes
3answers
2k views

SQL developer licensing [closed]

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 ...
-1
votes
1answer
146 views

How to data transpose in sql view?

Table1 Name CITY RANK Manish New delhi A Akash New delhi A Akash Aligarh B Vinay Barh C I have to transpose like Name New Delhi Aligarh Barh Manish A NULL ...
2
votes
1answer
2k views

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 ...
0
votes
1answer
1k views

Need help in putting the single quote and constant timestamp in plsql

Please help me in appending the Single quotes and constant timestamp to my query output. Given below is the expected output from my param file. Note: Query is executed through sqlplus Expected ...
6
votes
1answer
7k views

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 ...
0
votes
2answers
4k views

How to detect in which schema a procedure is called?

I'm struggling with a problem in Oracle 12.1 regarding to procedures. We are using a data isolation approach based on schemas. We use one schema as PUBLIC and each project has exactly the same ...
0
votes
1answer
13k views

ora 20001 error in oracle dbms scheduler

i have written a test job like begin DBMS_SCHEDULER.CREATE_JOB ( job_name => 'test_job' ,job_type =>'plsql_block' ,job_action => 'null' ,enabled => true ); end; / after a while when the ...
1
vote
1answer
124 views

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 ...
1
vote
1answer
11k views

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 ...
0
votes
1answer
736 views

Initializing values to a custom data type

I have defined a custom data type which I need to use in my procedure. Give below is my data type. CREATE or REPLACE TYPE CUSTOM_DATATYPE AS object( chkinvpre VARCHAR2(100), orderid NUMBER(10)...
-1
votes
1answer
3k views

Stored procedure syntax error [closed]

I am writing a procedure, independently the queries run fine with no errors.. But, when I run it as a procedure I get errors. Given below is my procedure create or replace PROCEDURE xyz(inuserid ...
0
votes
1answer
1k views

PL/SQL Developer - empty object list

I'm using PL/SQL Developer v9, brio intelligence 6.6 and on another computer SQL Developer v7. On version 7 everything is ok. My table objects are 'expanding' shows all avaiable databases. In version ...