PL/SQL :: No More Data To Read From Socket
Dec 9, 2012
When I am executing a query in Oracle Database version 11.2.0.1,I get an error as No more data to read from socket.In my sql query I had given all the joins as left outer join ,but when I comment two outer joins the result will be showing.
My SQL is :
select o.GENERAL_LEDGER as GROUP_NAME,
o.ACCNT_TYPE_CD AS GROUP_TYPE,
o.CUST_STAT_CD AS GROUP_STATUS,
pr1.START_DT AS EFFECTIVE_DATE,
[Code]...
when I comment last 2 outer join lines then the result will shows.
how can we resolve this error?
View 1 Replies
ADVERTISEMENT
Feb 5, 2010
I am getting an error through by application when i am trying to access a screen.
Error:No data to read from socket.
What could be the reasons for this error.
View 1 Replies
View Related
Dec 9, 2010
I am writing a PL/SQL code where in I would like to store the result set into a variable and then loop through it.I am using the following code and when I execute this peace of code it is giving me an error saying cannot able to read from the socket.
set serveroutput on
Declare
Type Start_End_Dates is Object(Start_Date Date,End_Date Date);
Type Start_End_Dates_Array is Table Of Start_End_Dates;
Dates Start_End_Dates_Array;
Begin
[code]....
View 4 Replies
View Related
Oct 9, 2012
We were facing some issue with crs startup and had to delete network socket files present in "/var/tmp/.oracle/".
what these "/var/tmp/.oracle/*" files do?..What informations are there in these files?
View 2 Replies
View Related
Jul 23, 2013
One of the customer is using Oracle database Oracle database 9i and its listener is running on port 1521. When Oracle database client are connected to database , it is connecting on multiple ports ( like 1600 to 1690 ) . if it is possible to restrict Oracle database client connection to only one specified port or not .
View 17 Replies
View Related
May 1, 2013
I select the data from sql server column type nvarchar2 and load into varchar2 but data once loaded looks very different and can't be read.
let say name column in sqlser values is 'Rajesh' then in oracle it looks like series of square shape.
View 1 Replies
View Related
Jun 16, 2004
I'm trying to read some data from external device via COMM Port.
Application is running n server and device is connected localy on my PC.
My device iz DPI605R for purpose of� pressure measuring.
View 6 Replies
View Related
Feb 12, 2010
I can store my video in to my database.but i cannot read such file.....using this procedure
ORA-29285: file write error
CREATE OR REPLACE PROCEDURE Extract_bfile
(p_id IN NUMBER)
IS
vblob BFILE;
vstart NUMBER := 1;
bytelen NUMBER := 32000;
len NUMBER;
[code]....
View 4 Replies
View Related
Mar 7, 2013
I need a tutorial for using utl_file package to read and load in to oracle data.
Oracle is in Linux box.
View 32 Replies
View Related
Oct 1, 2012
we have a created primary and physical standby databases. Before the switchover the application connected to dataguard allows updates on the database. However after the switchover, it allows read-only access and we are unable to update. Any comments prima-facie ?
View 12 Replies
View Related
Aug 12, 2011
I am using oracle 8i and need to read data from teradata using public link and views.
View 4 Replies
View Related
Aug 10, 2010
I am getting the file using CLIENT_GET_FILE_NAME. I need to read the data from the .xsl file and convert it into blob. The file should not be stored in DB.
View 8 Replies
View Related
Dec 7, 2010
Suddenly I can't open any of my physical standby databases read only. Alert log snippet and trace files follow post. I'm running 9.2.0.1.0 on all hosts, which are running AIX 5.2. I've successfully opened all physical standby databases read only numerous times in the past. solve this? Is it possible that these standby databases cannot be switched over to primary should the need arise?
Here's how I typically open a physical standby database read only:
alter database recover managed standby database cancel;
alter database open read only;
Errors in file /ora/product/9.2.0.1.0/rdbms/log/icps1_ora_27382.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-16000: database open for read-only access
[code]...
View 18 Replies
View Related
Feb 6, 2013
I have a Clob file as a in parameter in my PROC. . File is comma separated.need procedure that would parse this CLOB variable and populate in oracle table .
View 6 Replies
View Related
Dec 12, 2012
How to create a procedure to read data from database and export it into .csv format without using utilities
View 15 Replies
View Related
Feb 5, 2013
I have a database in access 2003 with the empno,empname and photo (bounded image). Using queries and an ODBC connection I have inserted the table into Oracle 8i (8.1.7). When I try to read the data using reports I get 'REP-1818 Unable to read data in image format.' error for the photo field.
View 5 Replies
View Related
Apr 9, 2013
1) If i do changes in table on primary database and if i open standby database in Read-Only mode, i can see those changes immediately only if Real Time Apply is enabled. Am i correct? Database version is 10.2.0.4
2) From 11g, It is possible to apply redo while the standby is open in read only mode. prior to 11g, it was not possible. Right?
3) Should I first cancel Managed Recovery prior to issuing “ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY”?
View 1 Replies
View Related
Jul 23, 2012
I have external file like (.csv or .txt) which contain million of record...i wnat to upload it in backend by using form 6i/10g.
by using package text_io.fopen i read it and by using for..loop conventional method insert record into table...but it will take time..
Is there any way like we use bulk collect and FORALL in backend for inserting data into table..
Is there any way to read external file at a time and insert it ...so minimize inserting time....process will become fast.
View 3 Replies
View Related
Apr 2, 2013
My job is running at 2 am and that time no application user is connected. Even though, my exp utility shows error on 3 tables (2 are temp tables), everyday. But when expdp is running without error, which was scheduled at 4 am.
Below are the error -
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
. . exporting table DW_TEST_MOTOR
EXP-00056: ORACLE error 1466 encountered
ORA-01466: unable to read data - table definition has changed
[Code].....
View 9 Replies
View Related
Feb 20, 2013
I have a table with a BLOB column ;
I want read data from table and insert to another table with a cursor
My code is :
procedure read_data is
cursor get_data is
select id,image from picture1;
id1 number;
pic blob;
begin
open get_data;
[code]....
when I run form , error FRM-40734 occurred
error in line " fetch .... "
View 1 Replies
View Related
Dec 27, 2010
my question is how to read ocr in oracle rac?
View 2 Replies
View Related
Jun 2, 2011
how to create script/steps that makes database read only to a particular user
View 2 Replies
View Related
Feb 12, 2012
i, I've Two database one for primary(GISC) and one for standby (GISCST) when i start open standby database i appeare erro :
ORA-16004: backup database requires recovery
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'D:\ORACLE\ORADATA\ORCLSB\SYSTEM01.DBF'
I take the copy the datafiles from primary database and Pase them to the Standby database and the Enviroment of two database is :
SPfile for primary(GISC) IS:
*.compatible='10.2.0.3'
*.control_files='C:\oracle\product\10.2.0\oradata\gisc\CONTROL01.CTL','C:\oracle\product\10.2.0\oradata\gisc\CONTROL02.CTL','C:\oracle\product\10.2.0\oradata\gisc\CONTROL03.CTL'
*.db_block_size=8192
[code]....
View 1 Replies
View Related
Jun 3, 2013
What privilege needs to give the user for ready only access for OEM for limited instances not all instances.
Purpose: our application dba team just want monitor the specific databases that why they asked to create read only access account for OEM for limited databases.
View 2 Replies
View Related
Mar 5, 2011
I am often supplied with a list of numbers to query against & normally take the easy option of editing the file & placing the select on each line. Like so. what to do to loop this. The input file would just be the numbers in a flat file.
Select status from thetable where MPN=�01234567890�;
Select status from thetable where MPN=�12345678901�;
Select status from thetable where MPN=�23456789012�;
Select status from thetable where MPN=�34567890123�;
View 4 Replies
View Related
Jan 30, 2013
I know how to use cursors to read all the records in a table.
But how can records that should be processed together be read in a loop, using cursors?
If there were, for instance persons from different nationalities, French, German, English, ..., I woluld like to read the first unknown number of persons from France and process that data, and then continue with the unknown number of germans and process that, and so on.
View 34 Replies
View Related
Dec 16, 2011
I Want Read Image Through URL..Image Is Placed In Another Server Which Is Not in Local Network.
View 1 Replies
View Related
Apr 25, 2012
row can be marked as read only in Oracle database
View 7 Replies
View Related
Oct 4, 2011
I need to select all records from table tmp_mape where value <loyaltyDebit id="5554431"> from xml_params is for example 5554431.
create table tmp_mape
(xml_params clob)
Example of xml
insert into tmp_mape values (
'<prolongationData mode="normal" exceptionCaseID="" xmlns="URL....
<customer status="active" xmlns:ns2="URL.....mobile.sk/client/twizard/communication/orderentry" xmlns:tns="URL....
<customerReferences>
<reference name="customerID" platform="bscs">2319375</reference>
<reference name="externID" platform="other">BSCS-PRD-CUSTOMER-2319375</reference>
<reference name="siteID" platform="clarify">S-061009-1893787</reference>
[code].....
View 1 Replies
View Related
Jun 11, 2013
I have a small doubt on CLOB reading and not able to do it in the query because it has very large strings in it.
create table TEST
(
col1 VARCHAR2(100),
col2 VARCHAR2(100),
col3 VARCHAR2(100),
col4 DATE,
col5 CLOB,
col6 BLOB,
[code]....
This data I am inserting from front end into test table via XML but here i just giving insert statement.Now , I have below query to insert the data into different table:
This query is working for col3 ='2' as its small string but for col3 ='1' its not working and giving character string buffer too small.
with indata as
(select 1 sn, (select dbms_lob.substr(col5) from test where col3 = '1') x
from dual
union all
select 2, null x from dual),
t1 as
[code]....
View 19 Replies
View Related