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

Server Administration :: No Data To Read From Socket

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

Error / Cannot Able To Read From The Socket

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

Clusterware :: Network Socket Files?

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

Multiple Socket For Database Communication

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

SQL & PL/SQL :: Data Loaded Looks Different And Cannot Be Read?

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

Forms :: Read Data From Serial Port?

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

SQL & PL/SQL :: Read Blob Data From Database Into Directory?

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

SQL & PL/SQL :: Utl_package - Read And Load Into Oracle Data?

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

Data Guard :: Database Is Read-only After Switchover On 11g?

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

8i - Read Data From Teradata Using Public Link And Views?

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

Forms :: Read Data From Excel And Store It In Blob?

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

Data Guard :: Cannot Open Physical Standby Read Only?

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

PL/SQL :: How To Read CSV File And Insert Data Into Oracle Table

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

SQL & PL/SQL :: How To Create Procedure To Read Data From Database And Export It Into CSV Format

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

Reports & Discoverer :: Unable To Read Data In Image Format

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

Data Guard :: Apply Redo While Standby Open In Read Only Mode?

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

Forms :: Read External File Data At A Time Like Bulk Collect Concept?

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

Server Utilities :: ORA-01466 - Unable To Read Data - Table Definition Has Changed

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

Forms :: Read Data From Table And Insert To Another Table With A Cursor?

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

How To Read OCR In Oracle Rac

Dec 27, 2010

my question is how to read ocr in oracle rac?

View 2 Replies View Related

Read Only User

Jun 2, 2011

how to create script/steps that makes database read only to a particular user

View 2 Replies View Related

Standby Not Open Read Only

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

Read Only Access Account For OEM?

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

Read From Input File

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

SQL & PL/SQL :: Read Different Number Of Records

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

Forms :: How To Read Image Through URL

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

SQL & PL/SQL :: Read Only Row In Database Oracle?

Apr 25, 2012

row can be marked as read only in Oracle database

View 7 Replies View Related

JDeveloper, Java & XML :: Read Value From XML

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

SQL & PL/SQL :: Read CLOB And Use In SQL Query?

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







Copyrights 2005-15 www.BigResource.com, All rights reserved