Site Search

Search words: sql and error Total hits: 20595
Search time: 0.064 seconds Run time: 0.074 seconds

Error: ORA-01033 ORACLE initialization or shutdown in progress - Rank: 1000: Error: ORA-01033 ORACLE initialization or shutdown in progress i have some login problem with oracle 8i, the following error: Error: ORA-01033 ORACLE initialization or shutdown in progress Can anyone help to solve it for me, thanks~ Re: Error: ORA-010 …
/forum/t/38120/2/ - 26013 - 2009-05-15 06:22:28 CDT - [ Highlight ]

java.sql.SQLException: ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [], [] - Rank: 893: java.sql.SQLException: ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [], [] We are trying to deploy a application with Oracle 9i Application Server on Solaris. While trying to connect to DB it gives the error java.sql.SQLExcept …
/forum/t/28158/2/ - 25953 - 2007-05-27 07:27:56 CDT - [ Highlight ]

ORA-06502:PL/SQL:numeric or value error: character string buffer too small in Oracle 10.2.0 - Rank: 858: ORA-06502:PL/SQL:numeric or value error: character string buffer too small in Oracle 10.2.0 Hi . I am getting this error for my PLSQL "ORA-06502:PL/SQL:numeric or value error: character string buffer too small" in ORACLE 10.2.0 installed on Linux. …
/forum/t/82335/2/ - 16634 - 2007-09-17 00:07:52 CDT - [ Highlight ]

ORA-01858 error in Oracle SQL query - Rank: 839: ORA-01858 error in Oracle SQL query I am getting the "ORA-01858: a non-numeric character was found where a numeric was expected" in a query on my Oracle db (9.2.0.4).� I have isolated the error to the following lines in the WHERE clause of my SQL, in which …
/forum/t/11400/2/ - 76052 - 2004-09-15 12:52:34 CDT - [ Highlight ]

Mutating Error Problem - Rank: 827: Mutating Error Problem Hi! I've developed one script to handle mutating error problem. It is showing some error message. I'm not sure about this. Can check it -- create table s_emp as select empno,ename from emp where 1=2; create tab …
/forum/t/91590/2/ - 53038 - 2007-11-01 00:16:33 CDT - [ Highlight ]

Error Creating STATSPACK on Oracle10g - Rank: 766: Error Creating STATSPACK on Oracle10g Hi All, We have an oracle10g r.2 standby database installed on a Hp-ux server ..which have some problems relating to memory allocations..i tried to install statspack on this database (Standbay database) but i got this …
/forum/t/85515/2/ - 64004 - 2009-09-15 20:02:26 CDT - [ Highlight ]

ORA-06502: PL/SQL: numeric or value error (merged) - Rank: 765: ORA-06502: PL/SQL: numeric or value error (merged) Recently we made the migration of Oracle 7.3 to Oracle 9i. However, we have problems using codes like the following example: DECLARE var NUMBER; BEGIN var := ' '; END; On Oracle 7.3 …
/forum/t/45774/2/ - 6394 - 2006-10-24 03:23:01 CDT - [ Highlight ]

After Logon Trigger error "ORA-06502: PL/SQL: numeric or value error" - Rank: 758: After Logon Trigger error "ORA-06502: PL/SQL: numeric or value error" I am using a security check trigger inorder to prevent the users from accessing the database if their OS_USERID and DB_USERID dosn't match. I have a trigger set up in SYS schema. Below …
/forum/t/58640/2/ - 7431 - 2006-02-09 03:56:32 CST - [ Highlight ]

ERROR ORA-01034 ORACLE not available, ORACLE database is not started ? - Rank: 739: ERROR ORA-01034 ORACLE not available, ORACLE database is not started ? ERROR : ORA-01034 ORACLE not avaiable..... All Services are running (Start).... but Local Database is not opening ? How i can got my data in Local DATABASE ? Re: ERROR ORA-01034 ORAC …
/forum/t/23928/2/ - 36384 - 2009-05-05 09:12:30 CDT - [ Highlight ]

Re: Sql error for above query when migarted from oracle 9i to oracle 10g - Rank: 736: Re: Sql error for above query when migarted from oracle 9i to oracle 10g ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support Regards Michel Sql error for above query when migarted from oracle 9i to oracle 10g …
/forum/t/141848/2/ - 11020 - 2009-03-11 08:15:05 CDT - [ Highlight ]

ORA-06502: PL/SQL: numeric or value error using Bulk - Rank: 733: ORA-06502: PL/SQL: numeric or value error using Bulk ORA-06502: PL/SQL: numeric or value error I 'm getting the above-referenced runtime error; dynamic SQL, fetching into a set of nested tables using BULK COLLECT. Can 't find anything in docs or on Meta …
/forum/t/96215/2/ - 12324 - 2008-02-04 16:01:42 CST - [ Highlight ]

sql error - Rank: 733: sql error Hi All When i run the following the query i'm getting an error as : ORA 009933 : SQL COMMAND NOT PROPERLY ENDED at the 'FROM' SELECT 'On-Call Unit Price' calc_type, to_char(low,'DD-MON-YYYY') low, to_char(low,'Q') qtr, to_cha …
/forum/t/122367/2/ - 11604 - 2008-07-24 10:35:29 CDT - [ Highlight ]

ORA-06502: PL/SQL: numeric or value error: number precision too large - Rank: 729: ORA-06502: PL/SQL: numeric or value error: number precision too large Hi there. I am getting a very strange error message when I try to call a stored procedure. I am calling the following stored procedure: PROCEDURE MyProc(my_field_name IN fields. …
/forum/t/99174/2/ - 10080 - 2008-03-19 10:18:03 CDT - [ Highlight ]

replication script ERROR .. help me urgent .. script attached.. - Rank: 729: replication script ERROR .. help me urgent .. script attached.. HELLO , I HAVE USED SCRIPT FOR IMPLEMENTING REPLICATION. I HAVE FOLLOWED THE FOLLOWING GUIDELINES.. ..my 2 database are CAMRY AND TATA..the spooled result is camry_alert.doc & tata_alert.doc …
/forum/t/27632/2/ - 41881 - 2007-07-26 11:14:57 CDT - [ Highlight ]

Create sp - Rank: 723: … tored procedure. Since I've not used PL SQL in years, it seems to be complicated to me now.. I would appreciate any kind of help. I created a table called auditing. This table needs to be inserted/updated via the SP by comparing/evaluating with anothe …
/forum/t/147394/2/ - 260634 - 2009-08-21 19:55:58 CDT - [ Highlight ]