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

Exception handling for insert statements in plsql code

if i have 3 insert statements in my plsql code. lets assume them as insert_1, insert_2, insert_3. my conditions be like : if insert_1 statement successfully executed then automatically insert_3 should be executed as well as if insert_3 executed…
Ganesh galla
  • 15
  • 1
  • 4
-1
votes
2 answers

SQL expression is of wrong type

Trying to run the following on SQL developer declare type hType is table of number not null index by BINARY_INTEGER; items_v hType; references_v hType; keyId number; begin keyId := 1234567; select i.item bulk…
James Blues
  • 3
  • 2
-1
votes
1 answer

Procedure PL/SQL to call a web service rest

I have to call in a PL/SQL procedure this web service rest. I did this script to call this web service rest and download the table : { DECLARE l_param_list VARCHAR2(512); l_http_request UTL_HTTP.req; l_http_response UTL_HTTP.resp; …
filippo
  • 3
  • 2
  • 8
-1
votes
1 answer

Update specific rows in a column

I have a column with 82 rows(from table1) and I want to update just the 76 rows in it with different values from another table(table2). Avoiding 6 specific rows(1, 10, 38, 39, 46, 77). Leaving these rows with null values. I used cursor to save all…
Blank
  • 11
  • 2
  • 14
-1
votes
1 answer

ORA-6504 Type of result set variables does not match

I am trying to print records that are mismatching (by some criteria) in my two tables that I have queried below in my procedure CREATE OR REPLACE PROCEDURE one_two_mismatch( p_rc OUT SYS_REFCURSOR, p_rc2 OUT SYS_REFCURSOR ) AS …
Priya Thakur
  • 11
  • 3
-1
votes
1 answer

How to check which rows has been generated error while import data from Excel file to the table in Oracle

I have an Excel file with 10,000 records. I want to import this file into a table in an Oracle database. But I found some error while importing the data. How can I check which records has been generate as error while import? Here is the code to…
user7382447
-1
votes
1 answer

Run plsql procedure from concurrent on Oracle

I am trying to create a stored procedure that send parameter input into table. When I tried to compile my store procedure from SQL Developer it was running well,but i want to run this procedure from Concurrent in Oracle EBS 12. However, this is the…
Keepo
  • 49
  • 1
  • 6
-1
votes
2 answers

Can't create a table and select from it while in a plsql procedure in oracle

create or replace procedure sp_test as begin CREATE TABLE T AS SELECT col1,col2 FROM t1; FOR N IN (SELECT * FROM T) LOOP UPDATE t1 SET t1.col1='value' where col2='value2'; END LOOP; drop table T; end; / I need to select data into t table from…
goodlink
  • 1
  • 1
-1
votes
1 answer

ORA-12514: TNS: no listener, and unable to turn on /off lsnrctl

I am unable to log in my database, with the message ORA-12514: TNS: no listener I tried to run lsnrctl start / set log_status off, then it loads for a few minute and returns TNS-01153 : Failed to Process the String I also realize that the…
Peterjohn David
  • 1
  • 2
-1
votes
2 answers

Using '&' in a where clause

Executing the code in SQL Developer. It seems to take the '&' as an input command rather than a character. Is there a way around this guys. Thanks in Advance :) Select * from table1 where column1 = 'M & S Simply Food; Sorry just adding up to my…
Riche Risus
  • 25
  • 6
-1
votes
1 answer

pl/sql need help undestanding

trying to get total sales for a specific zip; I have done a couple of these, but cant seem to get the total and I'm missing something. Tables are Customers that has the zip, sales that has the gross sale amount. This one executes complete but no…
Noir
  • 1
-1
votes
3 answers

Insert from one table into another with commit Intervals

I have written a procedure to insert data from one table into another table. There is a huge amount of data - a total of 106 millions rows. So I want to put a commit interval on the query. I have found this script that normally will work and will…
Anas Rafei
  • 21
  • 1
  • 6
-1
votes
1 answer

FORALL update is updating only last record from collection and it's giving error ORA-22160: element at index [1] does not exist error message

FORALL update is updating only last record from collection and it's giving error ORA-22160: element at index [1] does not exist. I have scenario were i have to update million of records. When i execute the below code the update is happening only for…
Kevin
  • 1
  • 1
  • 3
-1
votes
4 answers

Write a query to get output as shown below

A table name player having some columns & data in the table are as follows: **PID**|**PNAME**|**CITY**|**TEAM**|**SALARY**|**NO_OF_PENALTIES** 1001 ozil istanbul germany 500000 1 1002 messi madrid arsenal 500000 2 …
user7382447
-1
votes
1 answer

synchronization between PL sql developer to sql server

I'd be happy if someone could help me. I need to get data from PL sql developer oracle and import of sql server, I want to do automatic synchronization. now I am exporting an Excel file from PL sql developer oracle, and load the file into sql…
רון כהן
  • 1
1 2 3
…
99 100