04-23-2007
Bus error(coredump)
Hi,
control file is
OPTIONS ( ERRORS=99999999)
LOAD DATA
INFILE=${/usr/sap/A2/xchange/dataload/bwload/inbound/OOCQFULL.DAT}
INTO TABLE "OOCQ03DY_TMP"
INSERT
(PRODHNO POSITION(01:18),
PAPRODHNO POSITION(19:36),
PHITEMNM POSITION(37:54),
PHITEMDS POSITION(55:94),
PHITCDNM POSITION(95:134),
PDHRLVCD POSITION(135:135),
PRODTY POSITION(136:137),
PDRLFL POSITION(138:138),
PDFCFL POSITION(139:139),
PDCPFL POSITION(140:140),
MKSRSQNO POSITION(141:153),
PDPBFL POSITION(154:154),
PHIMPCDS POSITION(155:224),
PDDAUDFL POSITION(225:225),
PHODMCD POSITION(226:228),
PRODCGGP POSITION(229:248),
PNFMTCD POSITION(249:250)
)
ksh file is
#!/bin/sh
. /home/bwload/.profile
$ORACLE_HOME/bin/sqlldr as/as2005@AMERICAS.NET control=gpg.ctl
log=gpg.log
retcode=`echo $?`
case "$retcode" in
0) echo "SQL*Loader execution successful" ;;
1) echo "SQL*Loader execution exited with EX_FAIL, see logfile" ;;
2) echo "SQL*Loader exectuion exited with EX_WARN, see logfile" ;;
3) echo "SQL*Loader execution encountered a fatal error" ;;
*) echo "unknown return code";;
esac
and the error i am getting is
ksh sql.ksh
SQL*Loader: Release 9.2.0.6.0 - Production on Mon Apr 23 07:17:58 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
sql.ksh[3]: 4555 Bus error(coredump)
SQL*Loader execution successful
logout
Regards,
Srinivas
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi friends,
i am getting the following error when i am using sql loader.
SQL*Loader: Release 8.1.7.4.0 - Production on Tue Apr 19 13:00:07 2005
(c) Copyright 2000 Oracle Corporation. All rights reserved.
SQL*Loader-704: Internal error: ulconnect: OCIServerAttach
ORA-12535:... (4 Replies)
Discussion started by: sveera
4 Replies
2. UNIX for Dummies Questions & Answers
aix 5.3 ML1
system was functioing well, when suddenly telnet session hung and then I got the following message "Bus error(coredump)"
would appreciate if anyone would assist as to what to do next. (3 Replies)
Discussion started by: Student37
3 Replies
3. UNIX for Advanced & Expert Users
Hi,
I am using HP-UX.
While i try to run the Sqlplus command using the shel script in encounter the following error:
<shell script name>: some number Bus Error(coredump)
What may be the reason behind this.
I read few previous threads in this forum where i found some similar case. There it was... (2 Replies)
Discussion started by: Jayesh
2 Replies
4. UNIX for Dummies Questions & Answers
Hi Folks,
I have created a number of unix scripts that i can run from the scheduler on a server-side application that we use (Chordiant Marketing Director). All scripts are working except one. This last script is a user load script which first truncates a table and then loads it using a flat... (2 Replies)
Discussion started by: jibbadiah
2 Replies
5. UNIX for Dummies Questions & Answers
Hi all,
I am getting bus error problem in SunOS. Can you please help me out in this regard.
Actually, my entire code till the last line has been executed. But after tht i am getting a bus error. Please help me.
Thanks in advance.
Charu. (4 Replies)
Discussion started by: charu
4 Replies
6. Shell Programming and Scripting
hi all,
how to handle sql loader errors in unix shell
??
thanks in advance
gemini (3 Replies)
Discussion started by: gemini106
3 Replies
7. HP-UX
Hi all,
I am quite weak in C but I need to get some work done. Hope someone can help me out. I keep getting this error when i try to run my C application in my HP-UX 10.20 machine.
Some code snippet:
Month(DBTime) =====This is a function which will return variable "CutOffTime" to be use... (5 Replies)
Discussion started by: Vision©
5 Replies
8. Shell Programming and Scripting
Hi ,
I have my log file something like this
(07/29/2009 00:02:24.467) 367518 (07/29/2009 00:02:26.214) 949384011
(07/29/2009 00:02:26.236) 367524 (07/29/2009 00:02:28.207) 949395117
(07/29/2009 00:02:28.240) 337710 (07/29/2009 00:02:30.621) 949400864
I am trying to insert the data... (3 Replies)
Discussion started by: rdhanek
3 Replies
9. UNIX for Dummies Questions & Answers
HI Experts,
I am pretty new to scripting and i need to create a perl or shell script which should fetch a file from local directory and insert the data into a table using sql loader. This will be later added to chron job to run daily and fetch all files and load them into
the table.
Also i... (1 Reply)
Discussion started by: sam1234
1 Replies
10. UNIX for Dummies Questions & Answers
HI Experts,
I am pretty new to scripting and i need to create a perl or shell script which should fetch a file from local directory and insert the data into a table using sql loader. This will be later added to chron job to run daily and fetch all files and load them into
the table.
Also i... (1 Reply)
Discussion started by: sam1234
1 Replies
LEARN ABOUT PHP
oci_parse
OCI_PARSE(3) OCI_PARSE(3)
oci_parse - Prepares an Oracle statement for execution
SYNOPSIS
resource oci_parse (resource $connection, string $sql_text)
DESCRIPTION
Prepares $sql_text using $connection and returns the statement identifier, which can be used with oci_bind_by_name(3), oci_execute(3) and
other functions.
Statement identifiers can be freed with oci_free_statement(3) or by setting the variable to NULL.
PARAMETERS
o $connection
- An Oracle connection identifier, returned by oci_connect(3), oci_pconnect(3), or oci_new_connect(3).
o $sql_text
- The SQL or PL/SQL statement. SQL statements should not end with a semi-colon (";"). PL/SQL statements should end with a semi-
colon (";").
RETURN VALUES
Returns a statement handle on success, or FALSE on error.
EXAMPLES
Example #1
oci_parse(3) example for SQL statements
<?php
$conn = oci_connect('hr', 'welcome', 'localhost/XE');
// Parse the statement. Note there is no final semi-colon in the SQL statement
$stid = oci_parse($conn, 'SELECT * FROM employees');
oci_execute($stid);
echo "<table border='1'>
";
while ($row = oci_fetch_array($stid, OCI_ASSOC+OCI_RETURN_NULLS)) {
echo "<tr>
";
foreach ($row as $item) {
echo " <td>" . ($item !== null ? htmlentities($item, ENT_QUOTES) : " ") . "</td>
";
}
echo "</tr>
";
}
echo "</table>
";
?>
Example #2
oci_parse(3) example for PL/SQL statements
<?php
/*
Before running the PHP program, create a stored procedure in
SQL*Plus or SQL Developer:
CREATE OR REPLACE PROCEDURE myproc(p1 IN NUMBER, p2 OUT NUMBER) AS
BEGIN
p2 := p1 * 2;
END;
*/
$conn = oci_connect('hr', 'welcome', 'localhost/XE');
if (!$conn) {
$e = oci_error();
trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
}
$p1 = 8;
// When parsing PL/SQL programs, there should be a final semi-colon in the string
$stid = oci_parse($conn, 'begin myproc(:p1, :p2); end;');
oci_bind_by_name($stid, ':p1', $p1);
oci_bind_by_name($stid, ':p2', $p2, 40);
oci_execute($stid);
print "$p2
"; // prints 16
oci_free_statement($stid);
oci_close($conn);
?>
NOTES
Note
This function does not validate $sql_text. The only way to find out if $sql_text is a valid SQL or PL/SQL statement is to execute
it.
SEE ALSO
oci_execute(3), oci_free_statement(3).
PHP Documentation Group OCI_PARSE(3)