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

Listing procedure parameters in PL/SQL

I am able to retrieve a list of all procedures by querying dba_procedures. However I am only able to extract the procedure names. But I also need their parameters. Now, I know that I can access the "text source of the stored objects accessible to…
JB2
  • 1,587
  • 2
  • 24
  • 40
3
votes
1 answer

PL/SQL Developer won't run read queries against read-only linked database

I just installed PL/SQL Developer (version 10.0.5.1710), and my second query is: SELECT * FROM MySchema.MyTable@DBRead This is kicked back with: ORA-16000: database open for read-only access ORA-02063: preceding line from DBRead The database is…
user565869
3
votes
2 answers

Connect to MS SQL server from PL/SQL Developer

I have PL/SQL Developer installed on my machine. Version:-7.1.2 I want to connect to MS sql server from PL/SQL Developer. I have SQL server address, username and password with me. I tried to search for the solution every possible way. Can anybody…
user3013022
  • 196
  • 1
  • 3
  • 16
3
votes
1 answer

PL/SQL Developer runs queries faster when contains comments

I'm trying to improve performance on an SQL query against an Oracle 10g database. I have the following two queries: Query 1 SELECT DISTINCT WMS_EVENT_LOG.LOG_ID, WMS_EVENT_LOG.EVENT_ARG4, WMS_EVENT_LOG.EVENT_TYPE, …
Dodzi Dzakuma
  • 1,406
  • 2
  • 21
  • 39
3
votes
2 answers

Am using the below Function to decrypt a code ? Could any help to resolve?

function ibp_crypto_decrypt ( p_session_id in RAW) return raw is l_decrypted_raw RAW(2048); l_encrypted_raw RAW(2048) := p_session_id; l_key RAW(128) :=…
Ranjith Kumar
  • 51
  • 2
  • 5
3
votes
2 answers

PL/SQL developer: debugging hangs on certain code

I have noticed that when debugging code with PL/SQL Developer, debugger hangs on stepping over certain code. The first guess was to blame that line of code, but further investigation detected nothing suspicious in it. Just simple operations inside…
Yaroslav Shabalin
  • 1,645
  • 3
  • 17
  • 29
3
votes
3 answers

Variables in where clause in Oracle PL/SQL Developer

In ORACLE PL/SQL DEVELOPER, am I able to do the following as I could easily do in SQL Server? DECLARE @EmpIDVar INT SET @EmpIDVar = 1234 SELECT * FROM Employees WHERE EmployeeID = @EmpIDVar This seems like such a simple thing and yet it seems…
user3359423
  • 99
  • 2
  • 5
3
votes
1 answer

How to select results between two dates or by single year/month/day in oracle? (to_date, extract,sysdate)

I have a table for orders and it has 2 column with DATE types: delivery_date and order_date. In my sqldeveloper, all the dates I've inserted via Java or by hand are in the format 10.01.25 for the 25th Jan of this year. When I try to see the the…
neverMind
  • 1,757
  • 4
  • 29
  • 41
3
votes
1 answer

How to acess locally installed Oracle 11 g throught PL/SQL Developer 9

I need to develop in PL SQL using PL/SQL developer but I don't have idea how to make both oracle 11g and pl/sql developer work in the same machine because pl/sql developer need 32 bit oracle client installed when oracle did not require client when…
Tnsman
  • 31
  • 1
  • 1
  • 3
3
votes
2 answers

Oracle: DML operation inside a query

I'm getting this error: cannot perform a DML operation inside a query when i tried to execute the query select st_atten_up(1,7) from dual; the code has given below. create or replace FUNCTION st_atten_up(stu_id IN student_info.id%type,app_mon IN…
nixon1333
  • 531
  • 1
  • 9
  • 23
3
votes
3 answers

How can I call a function inside a procedure in plsql

I want to call a function inside a procedure and get it's value so I can use within the procedure but I have no idea how to do that ?? Any ideas ?? My function is the following one , this function returns a collection of employees' ids whose salary…
Lara Dax
  • 131
  • 2
  • 5
  • 10
3
votes
1 answer

PL/SQL error receieved on making of an XML file

I am trying to make an XML file using PL/SQL procedure by using the following code:- create or replace directory temp_dir as 'C:\XML'; grant read, write on directory temp_dir to hr; DECLARE doc DBMS_XMLDOM.DOMDocument; xdata …
Femme Fatale
  • 870
  • 7
  • 27
  • 56
3
votes
1 answer

executing an oracle package function

Hi i have an oracle function already present in the database which i have to use. if i call the function as below it works fine select PKG_Util.employeedetails('12345') from dual; But if i try to pass in multiple identifiers, this statement doesnt…
Justin Russo
  • 339
  • 1
  • 8
  • 22
3
votes
2 answers

dropping a very annoying trigger

I am stuck in a very unusal problem. There's one trigger I'd like to drop. Now when I drop it, it is dropped successfully. drop trigger HRCS.hr_external_salary_in_trigger But when I run this command then I can see the trigger again: select * from…
Jaanna
  • 1,620
  • 9
  • 26
  • 46
3
votes
3 answers

using define statement in PL/SQL developer

This is one of the tasks from my homework assignement: DEFINE countryid = CA DECLARE country_record countries%ROWTYPE; BEGIN SELECT * INTO country_record FROM countries WHERE country_id = '&countryid'; END; According to the task…
spin_eight
  • 3,925
  • 10
  • 39
  • 61
1 2 3
…
99 100