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

pl/sql varray with a cursor

Could someone tell me what is wrong with this code. My aim is to write a procedure which is passed an employee’s name, loads all the names and salaries from the employee table into a VARRAY, and then prints out the names and salaries on…
Dave Fisher
  • 1,033
  • 3
  • 10
  • 10
2
votes
2 answers

Why is my VARCHAR2 being converted to a LONG in my PL/SQL?

I am using PL/SQL Developer 9.0.6, working on an Oracle 11g database. I have a procedure in a package that creates some dynamic SQL to be run with execute immediate. The variable vSQL is declared as varchar2(4000). My procedure builds and runs…
Welton v3.62
  • 2,210
  • 7
  • 29
  • 46
2
votes
1 answer

Passing Array parameter from C# to Oracle collection type of table

I have declare a collection Table and record in PLSQL Specification. type loan_recov_rec is record(v_prncpl_ed_cd number(3),v_prncpl_recov number (7),v_int_ed_cd number(3), v_int_recov,number(5)); type loan_recov_tbl is table…
Shailesh
  • 980
  • 8
  • 16
2
votes
1 answer

Ora-01008 with substitution variables

I have an Oracle query which works fine when I use the command window but does not in an SQL window. I use Pl/SQL Developer so the command window is like the DOS window. The query is as follows: SELECT EMPLOYEE_ID, FIRST_NAME, &&COLS FROM…
Blood-HaZaRd
  • 2,049
  • 2
  • 20
  • 43
2
votes
2 answers

Updating Column B Value with Clumn A Old Value

Created the following VendorAccount Table VendorAccount (Ven_AccountId, Ven_RegNo, Ven_Invoice_RefNo, TotalAmount, Paid_ToVen , Balance ) In the above table the value of TotalAmount is came from another…
Usman YousafZai
  • 1,088
  • 4
  • 18
  • 44
2
votes
1 answer

dynamic pivoting

I am hoping to get some help on a view which needs to be pivoted, I am not sure though. View is in following format: CASE CASE_ORDER MANAGER MONTHLY_CASES FISCAL_CASES …
user1804548
  • 111
  • 6
2
votes
1 answer

overloading procedure in package

Below is the HEADER for the Package TASK5 CREATE OR REPLACE PACKAGE TASK5 AS PROCEDURE TASK5APROCEDURE ( REG_NO IN NUMBER, CERT_TITLE OUT VARCHAR2, E_DATE OUT DATE, C_MARKS OUT INTEGER); PROCEDURE TASK5BPROCEDURE ( CERT_ID …
Pravin Agre
  • 373
  • 2
  • 5
  • 17
2
votes
1 answer

PL DOC source forge - 2 issues

I'm attempting to use PLDOC source forge with my code to generate a neat page with comments of my liking. I'm coming across 2 issues, any help would be appreciated: I've been using tags (/**, */) to make comments and this works perfectly for…
KMISH
  • 21
  • 2
2
votes
1 answer

Oracle SQL, SELECT clause using &input

I have an quite simple query SELECT id FROM table where ID in &data When I run this SQL I am prompted to type in some values to &data. I would like to be able to select several id's using this. i.e. &data = "11,12,13" but then I get an error…
Ishamael
  • 51
  • 1
  • 2
  • 9
2
votes
3 answers

pl/sql developer IDE

I'm using AllRoundAutomatation's Pl/sql developer, and now i'm having quite interesting problem, All I want is to configure CTRL+UP key combination for scoll up!. but I can't manage it, How Can I do This ? Caution: tools > preferences > go to user…
RustamIS
  • 697
  • 8
  • 24
2
votes
2 answers

PL/SQL if inside declaration

I'm wondering if there's any way to have an if statement inside the declaration of a PL/SQL procedure. E.g: procedure testing (no IN NUMBER, name IN VARCHAR2) IS if no = 0 then cursor c is select * from table where name =…
user1375026
  • 403
  • 4
  • 12
  • 23
2
votes
1 answer

Simple beginner Oracle PL/SQL help/fix needed for procedure creation

I am NEW to PL/SQL so please don't mark me down if this seems too beginner-like of a question. I have spent a couple hours working on this and am now seeking help. Additionally, please bear in mind that this code is incomplete. I'm seeking help to…
Shades
  • 285
  • 2
  • 3
  • 15
2
votes
1 answer

Trigger on one table field works for all table fields

I have a trigger which is for a few fields in a table. But for some reason, if another field is changed (which is not defined in trigger) then it still fires. CREATE OR REPLACE TRIGGER INTEGRATION_EMPLOYMENT AFTER UPDATE OF…
Jaanna
  • 1,620
  • 9
  • 26
  • 46
2
votes
1 answer

Running a PL/SQL procedure in a Perl script

I have a Perl script which takes a file as input and has PL/SQL (for statements and DBMS_OUTPUT.PUT_LINE) in it. I need to run make a database connection and run that file in Perl script.The pl/sql has Begin declare end section,with for statements…
ftw
  • 365
  • 2
  • 6
  • 16
2
votes
2 answers

Insert/Update in PL/SQL

I have made a procedure in PL/SQL which inserts data from one table to another on basis of primary key. My procedure is working fine but i can't figure out how will i update column CODE_NUMBER of my table MAIN if primary key already exists.…
Femme Fatale
  • 870
  • 7
  • 27
  • 56
1 2 3
…
99 100