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

Sql Data Manipulation

I have data in a table in following manner tablename : history page_url verified day ------------------------------------------ some_url1 true 2012-06-25 some_url2 true 2012-06-24 some_url1 false …
Saurabh Saxena
  • 3,005
  • 10
  • 31
  • 46
0
votes
1 answer

How to fetch the cursor from the last fetch in nested cursor?

I am stuck in a situation from which I am finding no solution. Let me give the PL/SQL code: begin outer_loop_counter := 0; inner_loop_counter := 0; -- Open first cursor open get_vacancy; --<> loop …
Samcoder
  • 345
  • 1
  • 4
  • 14
0
votes
1 answer

odbc connection for PL/SQL

I'm using PL/sql developer to create table.i used conncetion codings like Class.forName("oracle.jdbc.driver.OracleDriver"); con = DriverManager.getConnection( "jdbc:oracle:thin:@localhost:1521:test") ps = con.createStatement(); SQL_Str="Select *…
Dhana
  • 1
  • 1
  • 3
0
votes
1 answer

plugin for plsql developer 9.0

My job is to write plsql code in PLSQL Developer 9.0.6.1665. There are many formatting standards that I have to follow which cannot be accomplished using PL/SQL Beautifier Options. Then I planned to write a plugin for my custom formatting. In the…
chemicalkt
  • 816
  • 5
  • 16
  • 33
0
votes
4 answers

Extract code or script of database objects

I need to extract code(script) from all my functions, procedures, packages, views and tables, so that when I move to production I could run the script to create all the objects. While developing I did not take script backup of all database…
Jacob
  • 14,463
  • 65
  • 207
  • 320
0
votes
1 answer

Email table data as attachment, get table name and emal id as parameters

I'm tryng to code something like this CREATE OR REPLACE PROCEDURE EMAIL_TABLE (errbuf OUT VARCHAR2, retcode OUT NUMBER ) is cursor head is select column_name from all_tab_columns…
user987900
  • 105
  • 1
  • 3
  • 11
0
votes
3 answers

Is it possible to go back to line after error in PL/SQL?

I have tons of insert statements. I want to ignore errors during the execution of these lines, and I prefer not to wrap each line seperately. Example: try insert 1 insert 2 insert 3 exception ... I want that if an exception was…
Matan
  • 680
  • 2
  • 14
  • 24
0
votes
1 answer

Team Foundation Server MSSCCI Provider slowness issue

I've installed Team Foundation Server MSSCCI Provider 2010 and use it to connect Oracle PL/SQL developer (ver 7.1.5) to TFS 2010. now the problem is that the operations that require TFS (check-in, check-out,..., etc) is very slow and causing the…
Mohammad Shahrouri
  • 384
  • 2
  • 16
0
votes
1 answer

Invalid SQL statement error with refcursor

I am trying to get the results of the underlying statements. The SQL statements works without any problems. However, in order to print the results I would like to use refcursor. I get the following errors: ORA-00900: invalid SQL statement ORA-01008:…
Jaanna
  • 1,620
  • 9
  • 26
  • 46
0
votes
2 answers

Column data as column heading

I am facing a very nasty problem to create reports. For this, I would like to have column data as column headers. Tables: skill_table SKILL_ID | NAME 3431060 | Stomach 3431064 | Hand 3437806 | …
Jaanna
  • 1,620
  • 9
  • 26
  • 46
0
votes
1 answer

Splitting PLSQL result

I'm trying to fetch data from a database using PLSQL Developer, the total of rows that need to be fetched is more than 1,5 million. When I tried to fetch the data all together it will really take a long time. I'm going to split it into two fetching…
Andha
  • 907
  • 2
  • 11
  • 22
0
votes
1 answer

nested PLSQL in a tabular form

I am trying to achieve the following result (the first line is header) Level 1 | Level 2 | Level 3 | Level 4 | Person Technicals | Development | Software | Team leader | Eric Technicals | Development | Software | Team leader |…
Jaanna
  • 1,620
  • 9
  • 26
  • 46
-1
votes
2 answers

Oracle PL SQL works from SQL Dev. but not from the code

I'm slowly going nuts here...why does this peace of SQL code work from SQL Developer and not from C#? declare x integer; begin insert into aspa2_counters (shortname, description, devicegroupid) values ('TEST0', 'DESC0', 61) returning counterid into…
dakt
  • 620
  • 1
  • 9
  • 24
-1
votes
1 answer

When generating dat file using postgresql procedure there getting error

I’m getting super user access privileges err when I’m trying to generate the dat file using postgresql procedure. I’m facing one issue in postgresql procedure. Previously I used oracle DB. There I created one procedure for fetching values from…
Manikandan S
  • 1
-1
votes
1 answer

Preparing script for updating different values through view and running it in server side

I have an update statement: Update xxbl_conducting_section_v set volatge=11000, drawing_id=123 where spid in (23, 11,22) I need to run this script in nohup(server side for different voltages and different spids. There are 11000,22000,66000,13200…
Debojyoti Roy
  • 1
1 2 3
…
99 100