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

PLS-00103: Encountered the symbol "1" when expecting one of the following: (

Wrote the following PLSQL script to produce a report and am getting the error messages Error at line 5 ORA-06550: line 61, column 18: PLS-00103: Encountered the symbol "1" when expecting one of the following: ( I've been through the code many…
harrysolomon
  • 7
  • 1
  • 3
-1
votes
3 answers

PLSQL IF ELSE in Package procedure

I have a package which has 4 parameters. All the parameters will come from concurrent request. In that based on transaction type parameter the package should execute the set of statements.I just started with oracle. Below is my code CREATE OR…
user2181349
  • 65
  • 2
  • 9
-1
votes
1 answer

For Loop on item: 'TELLER' is not a cursor

I have the following cursor: FUNCTION managers_meerdere_depart RETURN t_managers_table_type AS CURSOR manager_ids IS SELECT manager_id, count(manager_id) AS teller FROM departments WHERE manager_id IS NOT NULL GROUP BY manager_id; When…
Verhelst
  • 1,492
  • 2
  • 22
  • 46
-1
votes
3 answers

how to create and execute a procedure dynamically having schema name and table name as in parameter in oracle

Update statement using dyanmic sql by passing schema name and table name as in parameter to a stored procedure. Now it is working. create or replace procedure p11(v_sal in number,v_schema varchar2,v_tab varchar2) v_sql…
Debasish
  • 51
  • 8
-1
votes
3 answers

How to iterate output of query to another select query as an input parameter?

I want to pass the output of the below query as an input parameter to another query. SELECT DISTINCT MV_sum.exch FROM LLDMA.MERCAUDIT_VOLUME_AGG_SUMMARY MV_sum, EXCHANGE_MAPPING ex_map WHERE MV_SUM.EXCH =…
ashwini
  • 75
  • 2
  • 5
-1
votes
1 answer

Decode values of a column in plsql

I have table in which there is a column which contains values as 1:2 or 2:3 or 2:3:4 etc. I need to decode these values on the basis of their values mentioned in the different table. like 1 is x and 2 is y. there are 5 values in the column. earlier…
Manjeet Berwal
  • 11
  • 1
  • 3
-1
votes
1 answer

PLS-00103: Encountered the symbol “;” when expecting one of the following:

What is wrong with my PLSQL? I get this error message: ORA-06550: line 4, column 0:PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:* & = - + ; < / > at in is mod remainder not rem <> or != or ~=…
Abdurrahman
  • 3
  • 1
  • 2
-1
votes
1 answer

Search a group of substrings from string and display all the records

I am using Oracle 11g. I am storing multiple values in a column separated by delimiter(#@#). I know it is wrong database design but since it is used for many years i can't do much about it. I need to perform a search operation where i pass multiple…
Prabhakar
  • 1
-1
votes
2 answers

Not able to see the results by using Dbms_Output.Put_Line

I am not able to see the results by using Dbms_Output.Put_Line in sql developer. The result is shown only once. When I execute it again, it is not shown. I checked a lot of workarounds described in google, but those haven't worked for me. I am…
getshere
  • 15
  • 6
-1
votes
1 answer

PL/SQL obscure code

I faced with obscure code on PL/SQL in my job, please, could you explain for me, what does that mean? PL/SQL execute 'select' request e.g. DECODE(SIGN(ABS(SUM(amount))) - :3, -1, 0, SUM(AMOUNT)), What is the ' - :3'? What is the function of?
Mykhailo Marufenko
  • 61
  • 6
-1
votes
2 answers

I want fetch substring from in oracle table between last '/' and before '.' from last in images table

I want to fetch substring from string in column between last '/' and last '.' . Here is sample date for IMAGE_PATH column name: sph/images/30_Fairhall_Court.jpeg sph/images/9_Pennethorne_House.jpeg rbkc/images/TAVISTOCK_CRESCENT.jpeg …
Anuj Kumar Kushwaha
  • 29
  • 1
  • 6
-1
votes
3 answers

ORA-00936: missing expression

I tried to solve this issue , but it stil there . Could you help me to solve it? insert into diskgroup_size ( type1 , name , total_mb , used ) VALUES ( SELECT 'BANK', name, total_mb, (total_mb-free_mb) as "USED" from…
ALwaleed ALdajani
  • 1
  • 1
  • 2
  • 4
-1
votes
2 answers

Reference to uninitialized collection

I need help with this error in the part 4 of my source code, when I want see I.DIRECTOR.ASIGNATURAS.COUNT, this is a nested table and show this error: 06531. 00000 - "Reference to uninitialized collection" *Cause: An element or member function…
malrios
  • 1
  • 2
-1
votes
1 answer

How to send these oracle results by email

ECILE TOTAL_DECILE_COUNT FULL_KYC PERCENTAGE -------------------------------------------------- Decile 9 5091 1936 38.03 Decile 8 12472 5580 44.74 Decile 7 29927 14838 …
Lutakome Albert Valéry
  • 19
  • 3
-1
votes
1 answer

expression of wrong type oracle error

I am trying to execute the below plsql program, but facing expression of wrong type. Could anyone let me know what might be the error? CREATE OR REPLACE PROCEDURE CLN_TBL (CTRLM IN VARCHAR2, CTG IN VARCHAR,SBCT IN NUMBER, RTDT IN NUMBER ) AS …
pyennamp
  • 11
  • 4
1 2 3
…
99
100