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

Sql query to find the dates between two

I have a problem that I would like to get the dates which are logged between two dates (i.e start& end dates). I have a table with the following records in it: Create table t ( a int, b date, c date ); insert into t values(1, to_date(…
Shruthi
  • 33
  • 3
3
votes
2 answers

Oracle stack trace line number does not match source code!

I got a stack trace from Oracle saying there was a problem on Line 299. No problem, I looked at that line in the package in question, and say that it's a line in an initialization block that sets a variable to 1, and does not call the procedure that…
FrustratedWithFormsDesigner
  • 26,726
  • 31
  • 139
  • 202
3
votes
1 answer

how to declare a date (with time) variable in pl/sql

I want to use a date( DD/MM/YYYY HH:MI:SS ) variable in pl/sql. I'm using the following code but it doesn't work : BEGIN declare dateMig date ; dateMig := to_date('19/05/2017 05:05:00', 'DD/MM/YYYY HH:MI:SS'); exec…
jane Doe
  • 137
  • 2
  • 2
  • 9
3
votes
1 answer

Encountered the symbol "TABLE" when expecting one of the following: := . ( @ % ; The symbol ":= was inserted before "TABLE" to continue.

I had written a function, looks like everything is fine but still I am getting the errors, Below is my function: create or replace FUNCTION TRANSFERQTYBTNDATES ( v_startDate IN DATE, v_endDate IN DATE, v_storeid IN NUMBER, v_areaid IN…
Mahesh
  • 35
  • 1
  • 8
3
votes
4 answers

display resultset from oracle 10g stored procedure

I am using PL/SQL Developer and i have written a procedure to run a report and i need to procedure to output the resultset. The procedure accepts input parameters and needs to output the resultset. I cannot use a view because the procedure calls…
RobLaw84
  • 175
  • 2
  • 5
  • 18
3
votes
2 answers

Utl_file fseek function giving error with large absolute offset?

I have to make a program that will use fseek to read data from pirticular position. i have to read data line by line,and in pirticular line i have to use fseek to read data. But when i am using fseek and absolute_offset is of big size (little bit…
Vineet
  • 5,029
  • 10
  • 29
  • 34
3
votes
2 answers

Add Fonts to PL/SQL Developer

How can I add more fonts in PL/SQL Developer? Should I use the font.properties file?
kupa
  • 1,861
  • 5
  • 25
  • 41
3
votes
1 answer

How to Assign a C++ Pointer to a C# Function

I am creating a C# DLL that will be used as a plug-in for the PLSQL Developer IDE, which is designed in C++. My C# DLL needs to accept a C++ pointer, then assign that pointer to a function or method, to be called later on. The IDE provides a…
Josh
  • 51
  • 6
3
votes
1 answer

Jump directly from one package body into another package body in PL/SQL developer

I'm using a trial version of PL/SQL developer 11.0.6.1796 and attempting to jump from package body A to package body B using a ctrl + click navigation. Instead of jumping to the B package body - I'm taken to the B package spec. Are there any…
Alex Biery
  • 65
  • 6
3
votes
5 answers

Assign value to variable based on condition (value of other variable) in PLSQL

I want to assign value to a variable based on if another variable is null or not. I know there is error in the same code i am giving below, but i tried like this and don't know how i can get it done. although it gives clear picture of what i want to…
prnjn
  • 386
  • 3
  • 5
  • 20
3
votes
1 answer

Trigger based on system time (DAY)

So I have trigger as following create or replace TRIGGER TWELVE_ONE BEFORE INSERT OR UPDATE OR DELETE ON ORDERS FOR EACH ROW DECLARE V_DAY VARCHAR2 (10); MyException exception; BEGIN SELECT TO_CHAR (SYSDATE, 'DAY') INTO V_DAY FROM DUAL;…
envyM6
  • 1,099
  • 3
  • 14
  • 35
3
votes
5 answers

PLSQL - Improving code efficiency

This question is regarding PLSQL - for improving the efficiency of the code and coding standards. Any help, pointers, references or suggestions are highly appreciated. Question: I have a plsql procedure with an INPUT parameter i_flag which is of…
Deepan
  • 117
  • 1
  • 1
  • 8
3
votes
2 answers

How to figure out Oracle Connection String from PL SQL Developer's connection?

I PL/SQL Developer installed (pre-loaded by my company) on my laptop, when I want to connect to an ORACLE database, all I give it is Database Name, User Name and Password and it connects successfully. I also have DBVisualizer installed on my…
Karthik Balasubramanian
  • 1,127
  • 4
  • 13
  • 36
3
votes
1 answer

Inserting French character into Oracle gets converted into some junk characters

Using PL/SQL Developer, I'm able to insert French character in my Oracle database without any error. Querying: SELECT * FROM nls_database_parameters WHERE parameter = 'NLS_NCHAR_CHARACTERSET'; Output: AL16UTF16 But when i retreive the data using…
donstack
  • 2,557
  • 3
  • 29
  • 44
3
votes
2 answers

Selecting from table is causing pl/sql to hang

Anytime I insert into my table the insert runs fine, as expected. I select select * from... from the table and it hangs forcing me to terminate the query, but only when my xml_file column is populated, if it isn't then it returns the results and…
Aaron
  • 61
  • 1
  • 9
1 2 3
…
99 100