Server Fault
Server Fault

Questions tagged [plsql]

10 questions
5
votes
3 answers

Initialization error while trying to connect to Oracle using SQLDeveloper

I've installed Oracle 11.2.0 and Allround Automations' SQLDeveloper on Windows 7 64-bit. When I run SQLDeveloper and and try to connect to Oracle, I get the below error: Initialization error Could not load…
Gali
4
votes
1 answer

PL/SQL Plus script just gives me numbers

I have an PL/SQL Script that I'm trying to run from the command shell with SQLPLUS. However, whenever I go to run it, All I get back is a number and a cursor waiting for some input. When I hit enter, it just increments the number and repeats the…
Scott
  • 209
2
votes
1 answer

Oracle ORA-19011: Character string buffer too small

I'm trying to do an insert from a XML column to a CLOB column and I end up with this error. ERROR at line 1: ORA-19011: Character string buffer too small Any ideeas of what i can do ?
Paul
  • 714
2
votes
1 answer

pl/sql Oracle syntax

I have a query in pl/sql that i need to migrate to ms sql. select count(*) from table1 t1 where (conditions1) and (conditions2) and variable = t1.column1(+) Could anyone tell me what the (+) after the column means ? (is it sort of a sum ?)
Paul
  • 714
2
votes
0 answers

Oracle concurrent programming execution methods

I created a package and a stored procedure under it to test a concurrent program. When I run it as an Oracle report executable method it works fine. But when I change it to PL/SQL stored procedure then it produces an error. Cause: FDPSTP failed…
user361045
  • 21
2
votes
1 answer

SQL, pl/sql, sqlplus: how to return a variable to DOS batch file?

I have a DOS batch file which invokes sqlplus, which executes some basic SQL contained in another .sql file, and I want the last part of it to return a value back to the dos batch file. However, while there are many examples via Google on how to do…
weiji
  • 268
1
vote
5 answers

Open source scripts for Oracle health check?

I want to put together some scripts to run an automated health check of Oracle 9i and 10g databases. Before I start from scratch, I was wondering if anyone know of any available open source scripts that I could use as a base for this project.
Roy
  • 4,596
0
votes
1 answer

Oracle APEX in browser over VPN

After lots of futzing around with all of the settings, I finally managed to get APEX to work on a remote server. To get that to happen, I had to grant my user the SYSDBA role, and I also included myself in the ORADBA group on that machine. I can log…
Will
  • 101
0
votes
1 answer

Intermittent "Oracle Communication: Failed to connect to server"

I recently had to move my Oracle 11g Database from a Windows 2012 R2 server to Windows 2022 server and I've been getting intermittent "Oracle Communication: Failed to connect to server or parse connection string" errors. If I reboot the server, it…
Prescott Chartier
  • 127
  • 1
  • 7
0
votes
1 answer

SQL Developer queries are very slow if I am not connected as sys

I want to run my PL/SQL Queries on SQL Developer and created a new user connection. But if I run: set serveroutput on size unlimited; begin dbms_output.put_line('Hello Oracle.'); end; / clear screen; It takes more then 100 seconds. But only if…
AStudentwhoneedsHelp
  • 1