07-19-2011
why ORA-00600: internal error code, arguments: [17059]?
I have code to update some records in MyTable1 in sql which I am calling from ksh file (unix script).
I am getting below error -
MyTable1 TABLE UPDATE FAILED : UPDATE MyTable1 SET ph_nr = '+44 (0)20 8960
1233' , update_dts = sysdate WHERE ID = 499037
ORA-00600: internal error code, arguments: [17059], [0xC000000F1E4DAEF0],
[0xC000000F1B7D78D0], [0xC000000FDF038F90], [], [], [], [], [], [], [], []
Lo
When I execute in Toad I am not getting any error- UPDATE MyTable1 SET ph_nr = '+44 (0)20 8960
1233' , update_dts = sysdate WHERE ID = 499037
So why the update is causing the error in case 1?
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hey guys, need some help. Running AIX Version 5.2 and one of our cron jobs is writing errors to a log file. Any ideas on the following error message.
Error: Internal system error: Unable to initialize standard output file
I'm guessing more info might be needed, so let me know.
Thanks (2 Replies)
Discussion started by: firkus
2 Replies
2. HP-UX
Hi:
i have writen a script that needs a finishing
Pourpouse is to find a particular error in a file after we enter file name
and the return msg would describe if >there is a error -> "Contact DBA"
if there is no oracle error ->"No ora error found."
for the same i have written a script... (6 Replies)
Discussion started by: techbravo
6 Replies
3. UNIX for Dummies Questions & Answers
I am getting a :; then
echo "Enter zero or one file"
echo "You must use a valid directory"
echo "Current directory is:" pwd
exit 0
fi
#Flag Variable
flag=1
#Code for no arguments
if ; then
for filename in *
do
if ; then
... (2 Replies)
Discussion started by: Brewer27
2 Replies
4. UNIX for Advanced & Expert Users
Hi,
I need to redirect internal internet requests to a auth client site siting on the gateway. Currently users that are authenticated to access the internet have there mac address listed in the FORWARD chain. All other users need to be redirected to a internal site for authentication.
Can... (1 Reply)
Discussion started by: mshindo
1 Replies
5. Shell Programming and Scripting
1 #!/bin/ksh
2 ################################################################
3 # Written by Johnson 12/03/2008
4 # Version 1.0
5 # This script executes some SQL to provide Spike Check Report to TNS team.
6 ... (3 Replies)
Discussion started by: shivanete
3 Replies
6. Solaris
Hi all,
Am intermittently getting the following errors on one of my databases.
Errors in file /oracle/HRD/saptrace/background/hrd_psp0_13943.trc:
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302:... (1 Reply)
Discussion started by: newbie_01
1 Replies
7. UNIX for Advanced & Expert Users
Hi - I am trying to grep all "ORA" errors in a log files.I have to grep all ORA errors except one error for example ORA-01653.How can exclude that error in "grep" command?
In following "grep" command I want to exclude "ORA-01653" error
grep -i ORA alert.log >>/tmp/ora_errors.txt
... (7 Replies)
Discussion started by: Mansoor8810
7 Replies
8. HP-UX
Dear All,
i am not able to start the 9i oracle database because of the following problems.
I log in into unix
and then into sqlplus
export oracle_sid=SATEST
startup nomount
i am getting the following errors
ORA-27300: OS system dependent operation:semget failed with... (3 Replies)
Discussion started by: alokpattar
3 Replies
9. HP-UX
HI All ,
I am using oracle 10g and HP AIX . I am getting the below error while running the package.
ORA-29280: invalid directory path
ORA-06512: at "SYS.UTL_FILE", line 41
ORA-06512: at "SYS.UTL_FILE", line 478
ORA-06512: at "DW_APP.PKG_ASS_FVC", line 595
ORA-06512: at line 2
... (4 Replies)
Discussion started by: Perlbaby
4 Replies
10. Red Hat
Hi,
User claim that job is running slow from their end.
I DBA found in database the below errors in alert log file.
ORA-27603: Cell storage I/O error, I/O failed on disk o/192.168.10.3/RECO_DM01_CD_01_drm01 at offset 13335789568 for data length 1048576
ORA-27626: Exadata error: 2201 (IO... (2 Replies)
Discussion started by: Maddy123
2 Replies
LEARN ABOUT PHP
fbsql_affected_rows
FBSQL_AFFECTED_ROWS(3) 1 FBSQL_AFFECTED_ROWS(3)
fbsql_affected_rows - Get number of affected rows in previous FrontBase operation
SYNOPSIS
int fbsql_affected_rows ([resource $link_identifier])
DESCRIPTION
fbsql_affected_rows(3) returns the number of rows affected by the last INSERT, UPDATE or DELETE query associated with $link_identifier.
Note
If you are using transactions, you need to call fbsql_affected_rows(3) after your INSERT, UPDATE, or DELETE query, not after the
commit.
If the last query was a DELETE query with no WHERE clause, all of the records will have been deleted from the table but this function will
return zero.
Note
When using UPDATE, FrontBase will not update columns where the new value is the same as the old value. This creates the possibility
that fbsql_affected_rows(3) may not actually equal the number of rows matched, only the number of rows that were literally affected
by the query.
PARAMETERS
o $
link_identifier -A FrontBase link identifier returned by fbsql_connect(3) or fbsql_pconnect(3).If optional and not specified, the
function will try to find an open link to the FrontBase server and if no such link is found it will try to create one as if
fbsql_connect(3) was called with no arguments.
RETURN VALUES
If the last query failed, this function will return -1.
SEE ALSO
fbsql_num_rows(3).
PHP Documentation Group FBSQL_AFFECTED_ROWS(3)