3,477 questions
1
vote
2
answers
45
views
Pass BLOB to stored procedure from SQL*Plus
How to call a stored procedure from SQL*Plus with blob input parameters?
Below a sample of the SP to be called:
procedure p_dummy_proc (sessionId varchar2, accountId integer, lobData blob, oId out ...
2
votes
1
answer
42
views
How to write multi-line headers in html output file of oracle sqlplus?
The output I need (I need to add multi-line headers):
The output I am getting:
My Query:
-- Enable SQL*Plus HTML Markup
SET MARKUP HTML ON SPOOL ON PREFORMAT OFF ENTMAP ON
SPOOL "C:\...
- 23
0
votes
1
answer
64
views
SQL*Plus HTML Markup: Preventing Raw HTML Tags from Appearing in Output File
Output needed in this format:
I am using SQL*Plus to generate an HTML report from an Oracle database using SET MARKUP HTML ON. However, the output file contains raw HTML tags as plain text instead of ...
- 21
1
vote
1
answer
12
views
Data commits to database without explicit commit
I have shell script which inserts/updates data into oracle tables, what I don't understand is there is no explicit COMMIT in the script but data is committed to database, how is this possible?
I have ...
- 149
0
votes
1
answer
74
views
PLS-00357: Table,View Or Sequence reference not allowed in this context when execute immediate inside block
I'm trying to use variables in a ALTER SEQUENCE statement inside a BEGIN END block.
When hard coding the Schema name and the sequence name it works perfectly. But when I try to use variables instead ...
- 76
1
vote
0
answers
30
views
Sql*Developer: i/o error: The Network Adapter could not establish the connection
When trying to connect to the database in sql*developer, I get the following line:
An error was encountered performing the requested operation:
I/O Error: The Network Adapter could not establish the ...
- 11
0
votes
1
answer
192
views
Python : Not able to connect to oracle db ORA-12537: TNS:connection closed
I am trying to connect to oracle database in mac system.
My team generally works on Java so for development. we generally do this to connect to db in java. We connect to ssh tunnel which allows us to ...
- 45
0
votes
2
answers
60
views
How to input Oracle query statements in Unix shell variables
I am trying to input an Oracle query statement into a variable in a Unix shell.
I want to remove the header of the SQL result value, so I want to include "set heading off" in the QUERY ...
0
votes
0
answers
34
views
Trying to open a sqlplus file via a python script is giving an error "SP2-0310: unable to open file". The file opens correctly when not using python
I am using
import os
# Specify the directory you want to change to, take input from keyboard
directory_path = r"C:\code\xyz\deployment\tbd\example"
# Change the directory
os.chdir(...
0
votes
0
answers
18
views
sqlplus cannot grant select v_$session right to a user
I want to grant sys.v_$session to user c##DSLI01 and so run the following command in sqlplus:
SQL> show user
USER is "SYS"
SQL> SELECT privilege, table_name FROM ALL_TAB_PRIVS WHERE ...
- 1,396
0
votes
1
answer
35
views
Oracle SQLPlus taking exclusive session and not allowing to run update statements from .Net application
I connected via sqlplus like this:
sqlplus user/password@SID
I have a .NET application which also connects to the same database using the same user and password. But once sqlplus is connected, it was ...
- 3,461
0
votes
0
answers
66
views
Inserting a file into a BLOB column (Oracle) from a ksh script using sqlplus for passing parameters (file)
I would like to insert my file (csv) into a BLOB column (Oracle), I use a Korn Shell script to call an insert sql script via a SQLPLUS statement. my problem is that I don't know how to pass my file as ...
0
votes
1
answer
45
views
Oracle SPOOL Not Returning Same Number of Rows
I have a simple SQL query which returns 21 rows of data when I run it in Toad.
However, when I SPOOL the results to a CSV, I always get less than 21 rows of data, e.g. 16 rows one run, then 10 rows ...
- 3
0
votes
1
answer
97
views
ORA-03113: end-of-file on communication channel - SQL Plus - Oracle Express Edition
SQL*Plus: Release 18.0.0.0.0 - Production on Wed Nov 13 09:30:39 2024
Version 18.4.0.0.0
Copyright (c) 1982, 2018, Oracle. All rights reserved.
Enter user-name: sys as sysdba
Enter password:
ERROR:
...
- 9
2
votes
0
answers
77
views
How to Replace IN Operator with JOIN in Dynamic Criteria Using JPA Specification?
I have a requirement to build a dynamic filter criteria based on filters I receive. Initially, I used the Specification approach, and it is working as expected in production. However, the new ...
- 453