Oracle Error ORA-04052?

Mar 12, 2008

Ok i have stored proc that is accessing another DB thru a DB link. Now i can run select statements on the remote DB without issue, but i recieve the ora-04052 error when i try to do it thru my stored proc.

here is the format of my query that it doesn't like

SELECT STATUS INTO V_STATUS
FROM myschema.ticket@remote.db.com
WHERE ID = V_ID;

View 1 Replies


ADVERTISEMENT

Error When Installing Oracle 10G

Jul 21, 2010

I have tried to install oracle 10g on my Windows XP. But during the installation I have got these errors:

"Enterprise manager configuration failed due to the following error. Error instanting EM configuration files. Refer to the log file U:\...\orcl6\emConfig.log for more details"

"VTA-1000 : The browser could not be launched with the file or

URL :%EM_UPLOAD_PORT%/em"

View 5 Replies View Related

Error On Oracle - ORA-03134?

Dec 14, 2010

i try to connect to Oracle DataBase Through my C# program

and i get this error: `ORA-03134`

View 4 Replies View Related

Error When Using INSERT INTO In Oracle

Jan 22, 2012

I have declared my table and it was created with no issue. This is the code I used to declare my table...

CODECREATE TABLE STUDENT
(
Sid NUMBER(5) CONSTRAINTS STUDENT_Sid_pk PRIMARY Key,

[Code]...

Now I am trying to INSERT INTO that table, but ORACLE doesn't like ANY data that I input..

CODEINSERT INTO STUDENT VALUES
2  (100, �McClure�, �Sarah�, �M�, '144 Windridge Blvd', 'Eau Claire', 'WI', 54703, 7155559876, 'SR', 14-JUL-1979, 8891, 10);

View 2 Replies View Related

ERROR While Installation Of Oracle

Dec 24, 2011

I m getting error while installing ORACLE 10.2.0.1 client on windows error is as follows :"The path is more than 1023 character....."

------------------------------------------------------------------------------
my PATH variable contains following value

D:\oracle\product\10.2.0\client_1\bin;C:\Program Files\CA\SC\CAWIN\;E:\oracle\product\10.2.0\db_1\bin;C:\Program Files\Common Files\NetSarang;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\PROGRA~1\CA\SC\CAM\bin;C:\Program Files\CA\DSM\bin

View 1 Replies View Related

SQL & PL/SQL :: Error In Oracle Collection

Aug 8, 2011

I got error in oracle collection

CREATE OR REPLACE PACKAGE BODY pkg_das_stag_to_master
AS
PROCEDURE sp_load_dasstage_security
AS
cursor cur_stag is
select Asset_id,
ID_ISIN,
ID_SEDOL1,
ID_CUSIP,
[code].........

error:

66/35 PLS-00302: component 'ASSET_ID' must be declared
66/35 PLS-00302: component 'ASSET_ID' must be declared
66/18 PL/SQL: ORA-00904: "TYP_SECURITY_VAR"."ASSET_ID": invalid identifier
63/1 PL/SQL: SQL Statement ignored

View 2 Replies View Related

Oracle 11g Login Error

Mar 17, 2013

I am new to Oracle and I have just installed 11g on my 64-bit laptop and after downloading and installing SQL Developer I can nolonger log in using DBSNMP and my specified password both from SQL PLUS or Developer retaining this error message : ERROR: ORA-01033: ORACLE initialization or shutdown in progress.

View 1 Replies View Related

SQL & PL/SQL :: Oracle 11g Function Error

Apr 16, 2013

I'm using the following code for a function which is working fine in Oracle 9i, but throwing error like ORA-06512 (Numeric value error) in Oracle 11g.

CREATE OR REPLACE FUNCTION Decrypt(toconvert VARCHAR2) RETURN VARCHAR2 IS
str_original VARCHAR2(30);
str_new VARCHAR2(30);
sub_str VARCHAR2(1);
j NUMBER;
[code]......

View 17 Replies View Related

SQL & PL/SQL :: Utl_file Error In Oracle 9i?

Oct 5, 2010

I have make utl_file. Its run in oracle 10 g. But when i run oracle 9i it give some error.

ERROR at line 1:
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "SYS.UTL_FILE", line 120
ORA-06512: at "SYS.UTL_FILE", line 204
ORA-06512: at "HR.EXP_DATA", line 9
ORA-06512: at line 1.

[code]......

View 3 Replies View Related

Oracle Streams 11g (11.1.0.7) - Getting Error?

Oct 4, 2010

Platform: Windows 2003
Streams Set up: One way Streaming at table level

The error: ORA-26786: A row with key ("REPT_NUM", "STATE_CODE", "SURVEY_ID") = (067305669, 49, J) exists but has conflicting column(s) "DATE_TIME", "PREV_PARENT_ID" in table TOPCATI_JOLTS.UNIT ORA-01403: no data found

We are consistently getting this error every other day and some weeks more often, different records of course. On the capture site the application does a process called split cases. In this process the application will take an old PK case num insert a new PK case number with all of the data of the old case (Parent level). At the unit (Child level) the application will change all of the units to this new FK case number. This means the old case (parent) is left with no child units. This is all one transaction.

Is it possible that streams may be applying the LCR's out of order? especially since that whole process is one transaction.

View 2 Replies View Related

PL/SQL :: Error While Using Oracle Client

Nov 19, 2012

I have installed an oracle client in my machine and at the same time the machine is having an express edition database installed .

My question is how can i make both the clients working ? The one which is installed later sets the path variable. Despite changing the value of path variable , i am unable to connect through the client .

View 3 Replies View Related

RAC/ASM Clusterware Installation :: ORA-03114 / Not Connected To ORACLE Error With Oracle DB Installation

Dec 3, 2012

I am getting "ORA-03114: not connected to ORACLE" while installing "Oracle Database 11GR2" on "Oracle RAC 11R2" cluster setup. I am getting this error at the time of "Oracle Database Configuration Assistant" configuration reaches till 39% on HP-UX 11.31 IA64 platform.

View 25 Replies View Related

Oracle 10g - Error (Server Not Found)?

Jan 23, 2010

i have installed oracle 10g. normally with that URL address

we can navigate to this URL in our browser and log in as the SYS user with the associated password, and connect as SYSDBA. Enterprise Manager can be used to perform common database administration tasks... but..,in my system when this procedure is run i'm receiving an error stating that the server cannot be found...

View 5 Replies View Related

Error While Creating Table In Oracle 10g?

Aug 19, 2008

If i create a table in Oracle 10g it givea me the follwoing Error.. what couls be the error...

ORA-00911: invalid character
create table shopper
(
cShopperId varchar2(30) primary key,
cPassword char(20) not null,
vFirstName varchar2(20) not null,

[code]....

View 1 Replies View Related

Connect To Oracle DB - Developer Error?

Apr 26, 2009

i've been trying to connect to the Oracle DB with Oracle SQL Developer.I get a message

State: Test Failed - IO Exception "The network adapter could not establish the connection"

When i go try tnsping 1521 It detects a connection by Oracle Database.And finally i get TNS-03505: Failed to resolve name

When i went into the "services.msc" and tryed to run the "OracleOraDb10g_home1TNSListener"

Got a message: "Error 3: The sytem could not find the specified path"

View 9 Replies View Related

Oracle 11g - Got Error On PL/SQL Developer / Could Not Initialize

Nov 25, 2011

i install the PL/SQL developer version 9.0.3.1641 on Windows-7 64 bit...i have Oracle 11g on this computer.when i run PL/SQL i got this error:

initialization error
could not initilize "c:\.......oci.dll"

make sure you have the 32 bits oracle client installed..what i need to install and from where to download ? (can i have link to download)

View 1 Replies View Related

Error While Starting Up Oracle Database

Jul 17, 2010

when i start the Oracle database, the database is mounted. Then when i issue the "alter database open resetlogs" command, i got the below error.

ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/data/oracle/NYP15S1D/data03/SYSTEM_01.dbf'

So i added the parameter "_allow_resetlogs_corruption=TRUE" in "init.ORA" file to force open the database but the Oracle instance crashed with following message.

In the alert log the following error is there:

ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [4000], [2], [], [], [], [], [], []

How can i resolve the issue?

Please note: the database is Oracle 9i, installed in UNIX AIX OS.

View 1 Replies View Related

DRG-50857 - Oracle Error In Dresoflush

Sep 12, 2011

We are doing the index optimize, but this time we get an error , how to fix this,

SQL> BEGIN ctx_ddl.optimize_index('IDX_OBJ_VIEW', 'FULL', 90); END;

*
ERROR at line 1:
ORA-20000: Oracle Text error:
DRG-50857: oracle error in dresoflush
ORA-01461: can bind a LONG value only for insert into a LONG column
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.CTX_DDL", line 740
ORA-06512: at line 1

View 2 Replies View Related

Oracle Error In Linux Fedora

Nov 20, 2006

I get this error when trying to log in to SQLPlus in Oracle

ERROR:

ORA-12516: TNS:listener could not find available handler with matching protocol stack

View 1 Replies View Related

ORA-12713 Error In Oracle Forms?

Oct 11, 2012

i am getting ora-12713 error in oracle forms output whle displaying text in textbox.

ORA-12713:character data loss in NCHAR/CHAR conversion
ORA-01403 : no datafound.

these two erros are cuming together in oracle 11g and some data is lossing. other its displaying.

View 3 Replies View Related

Error When Installing Oracle 11gR2?

Sep 12, 2013

here is the error faced when installing oracle 11gR2,

ERROR:
Exception in thread "main" java.lang.UnsatisfiedLinkError: /tmp/.colorls9rT/OraInstall2013-09-12_03-59-57PM/jdk/jre/lib/i386/xawt/libmawt.so: libXext.so.6: cannot open shared object file: No such file or directory
at java.lang.ClassLoader$NativeLibrary.load(Native Method)
at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1751)

[code]...

View 1 Replies View Related

Forms :: Run The Report In Oracle 10g Error

Jul 7, 2010

i tried to run the report via oracle froms 10g in BUTTON CLICK. But i got the error like "FRM-41219 : CANNONT FIND REPORT:INVALID ID". I did the Following code.

DECLARE
repid REPORT_OBJECT;
v_rep VARCHAR2(100);
rep_status varchar2(20);
BEGIN
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_EXECUTION_MODE,BATCH);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_COMM_MODE,SYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESTYPE,CACHE);

[code]....

View 8 Replies View Related

SQL & PL/SQL :: Oracle - Getting Error While Writing Procedure?

May 3, 2012

I am Getting the error when writing the procedure. How to Solve this Error .

Error: PLS-00306: wrong number or types of arguments in call to 'PUT_LINE'

View 5 Replies View Related

Windows :: Oracle DB Out Of Memory Error

Sep 4, 2012

My database is working fine till y.day. But today when I try to connect as sysdba i get the following error- let me know how to resolve the same

C:UsersAdministrator>set ORACLE_SID=sha

C:UsersAdministrator>sqlplus '/ as sysdba'
SQL*Plus: Release 11.2.0.1.0 Production on Tue Sep 4 05:11:14 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Enter password:
Connected to an idle instance.
SQL> startup mount

ORA-27102: out of memory
OSD-00026: additional error information
O/S-Error: (OS 1455) The paging file is too small for this operation to complete

View 4 Replies View Related

SQL & PL/SQL :: How To Send SMS Through Oracle - Service Not Available Error

Jul 2, 2010

I am learning How to send sms thru PLSQL gateway?

I have searched for it on internet & got 1 procedure on OTN. I also tried it. But it is giving me the Errors .

The procedure is as below :

create or replace procedure SEND_SMS(p_sender in varchar2,
p_recipient in varchar2,
p_message in varchar2) as
mailcon utl_smtp.connection;
begin

[code]....

I also tried to Execute the same Procedure. The execute statement is below :

EXECUTE send_sms('myemail@server.com', '9822553277@smsserver.com', 'My Subject', 'My Message');

But i got the errors as :

begin send_sms('myemail@server.com', '9822553277@smsserver.com', 'My Subject', 'My Message'); end;

ORA-29278: SMTP transient error: 421 Service not available
ORA-06512: at "SYS.UTL_SMTP", line 21
ORA-06512: at "SYS.UTL_SMTP", line 97
ORA-06512: at "SYS.UTL_SMTP", line 139
ORA-06512: at "ADMIN.SEND_SMS", line 13
ORA-06512: at line 2

View 2 Replies View Related

Getting Error After Oracle Software Cloning

Oct 4, 2013

I have a database(10.2.0.5.0) in solaris 10 , i simply take a tar backup of ORACLE_HOME andextracted them into another server (which is solaris 10 only) and linked the binaries after that when i connecting with sqlplus.

I am getting following error 

SQL*Plus: Release 10.2.0.5.0 - Production on Fri Oct 4 14:49:48 2013  Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.  Enter user-name: /as sysdbald.so.1: oracle: fatal: libskgxp10.so: open failed: No such file or directoryERROR:ORA-12547: TNS:lost contact  

I would like to tell that i have also oracle 11gr2 running on the server my oracle_base is same for both(10g 11g)but ORACLE_HOME is different. 

View 3 Replies View Related

Windows :: Error Regarding Oracle Connection?

May 20, 2013

error regarding oracle connection

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim oradb As String = "Data Source=CallTaxi; UserName = SCOTT; Password=TIGER ;"
Dim conn As New OracleConnection(oradb)
conn.Open()
Dim cmd As New OracleCommand

[code]...

Error msg:
The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception.

View 1 Replies View Related

TNS Error : Connecting To Remote Oracle DB From .Net

Sep 22, 2010

I have been trying to connect to an remote oracle db from c# .Net . I believe I have the proper code (Cos when the user id and password strings were omitted , it threw an error of invalid user Id and password).

Once this was properly provided , the connection is now throwing "TNS Error : No Listener " error . The same remote DB is perfectly connecting through TOAD and it is from the tnsnames.ora file of the local file that i got the connection string from . Hence , I don't thing its a problems with that as well.

View 7 Replies View Related

Insert Into Statement - Getting ORACLE Error?

Jan 22, 2012

I am creating the following two tables...no issues here:
CODECREATE TABLE COURSE_SECTION
  (
  Csecid NUMBER(8) CONSTRAINT COURSE_SELECTION_NUMBER_pk PRIMARY Key,
  Cid NUMBER(6) NOT NULL CONSTRAINTS COURSE_SELECTION_Cid_fk REFERENCES COURSE,
  Termid NUMBER(5) NOT NULL CONSTRAINTS COURSE_SELECTION_Termid_fk REFERENCES TERM,
 
[code]...

The issue I am having is actually inserting data into the table:
CODEINSERT INTO ENROLLMENT
  VALUES (100, 1000, 'A' );
INSERT INTO ENROLLMENT
  VALUES (100, 1003, 'A' );

[code]...

But I get an ORACLE error of

ORA-02291- integrity constraint (User1.ENROLLMENT_CSECID_FK) violated - parent key not foundHow can the parent key not be found when I have it declared/created in the above statement?

View 3 Replies View Related

Oracle Error In Windows-7 64bit

Oct 30, 2010

i installed windows-7 64bit and i try to run my program(that work's with Oracle 11g) i get this error:

Attempt to load Oracle client libraries threw BadImageFormatException this problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed

and from where i can download 64 bit oracle client ?

View 1 Replies View Related







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