09-13-2018
We have no access to create Directory. So we can't use SQL Loader in Oracle side.
As the FILE3 is very big we are getting error as below
at <?xml version="1.0" encoding="UTF-8"?>
SQL Error: ORA-01704: string literal too long
01704. 00000 - "string literal too long"
*Cause: The string literal is longer than 4000 characters.
*Action: Use a string literal of at most 4000 characters.
Longer values may only be entered using bind variables.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi all
I need to input values in a .csv file into my Oracle table running in Unix, I wonder what would be the command to do so...
The values are recorded in an excel file and I tried using a formatted text file to do so but failed because one of the field is simply too large to fit in the... (5 Replies)
Discussion started by: handynas
5 Replies
2. UNIX for Advanced & Expert Users
Hi all
I need to input values in a .csv file into my Oracle table running in Unix, I wonder what would be the command to do so...
The values are recorded in an excel file and I tried using a formatted text file to do so but failed because one of the field is simply too large to fit in the... (4 Replies)
Discussion started by: handynas
4 Replies
3. Programming
I'm having a oracle server and i'm having a table in that.
I'm having a linux server which is in network with the oracle server. I need to write a c program in linux env when on execution loads the table with the text file given as input.
Please explain me the flow of process in that and also... (6 Replies)
Discussion started by: rramprasad
6 Replies
4. UNIX for Advanced & Expert Users
Hi,
I have delimited file(|).
Sample data:
1|name|50009|DS24|0|12
2|name|30009|DS24|0|13
3|name|20409|DS24|0|14
4|name|20009|DS24|0|15
5|name|10009|DS24|0|16
I want to load this data into a oracle table (update and insert)
Please help me the commands and also... (1 Reply)
Discussion started by: unihp1
1 Replies
5. Shell Programming and Scripting
Hi....can you guys help me out in this script??
Below is a portion text file and it contains these:
GEF001 000093625 MKL002510 000001 000000 000000 000000 000000 000000 000001
GEF001 000093625 MKL003604 000001 000000 000000 000000 000000 000000 000001
GEF001 000093625 MKL005675 000001... (1 Reply)
Discussion started by: pallavishetty
1 Replies
6. Shell Programming and Scripting
Hi all,
How to load variable value into Oracle table? I have created a file validation shell script. After the validation completes, i need to update a Oracle table with the variable value...
Can someone help me how to do it? I have searched, but not able to get answer.
i have 4... (1 Reply)
Discussion started by: Amit.Sagpariya
1 Replies
7. Shell Programming and Scripting
Hi all,
How to load variable value into Oracle table? I have created a file validation shell script. After the validation completes, i need to update a Oracle table with the variable value...
Can someone help me how to do it? I have searched, but not able to get answer.
i have 4 variables... (2 Replies)
Discussion started by: Amit.Sagpariya
2 Replies
8. Shell Programming and Scripting
Hi all,
I have a data like,
0,R001,2,D
this wants to be loaded into a oracle database table.
Pl let me know how this has to be done.
Thanks in advance (2 Replies)
Discussion started by: raji35
2 Replies
9. Shell Programming and Scripting
Hi can anyone help me with a script to load output of the .ksh file into an Oracle database. I have attached sample output of the information that i need to load to the database (2 Replies)
Discussion started by: LucyYani
2 Replies
10. Shell Programming and Scripting
I need to create the shell script load the few 100 table using the SQLLDR.
Need to generate the control file for each table using oracle table.
table has "table names" and "column names" using this need create the control file.
example table rows below
table_nme column_nme
DEPT ... (2 Replies)
Discussion started by: pimmit22043
2 Replies
LEARN ABOUT DEBIAN
ospcat
OSPCAT(1) Reference OSPCAT(1)
NAME
ospcat - SGML print catalog
SYNOPSIS
ospcat [-b name] [--bctf=name] [-C] [--catalogs] [-c sysid] [--catalog=sysid] [-f] [--error-file=file] [-D directory]
[--directory=directory] [-R] [--restricted] [-v] [-h] [--help] [-P literal] [--public-id=literal] [-S literal] [--system_id=literal]
[-p name] [--parameter-entity=name] [-d name] [--doctype=name] [-l name] [--linktype=name] [-e name] [--entity=name] [-n name]
[--notation=name] [-s name] [--declaration=name]
DESCRIPTION
ospcat prints effective system identifiers found in the catalogs on the standard output. It doesn't check that the system identifiers
correspond to actual files. The return value is 0 if the last system identifier was successfully created and 1 otherwise.
OPTIONS
The following options are available:
-b name, --bctf=name
Use bctf name for output.
-f file, --error-file=file
Append error messages to file file.
-v, --version
Display the program version.
-h, --help
Show this help text.
-c sysid, --catalog=sysid
Use catalog sysid.
-C, --catalogs
Arguments are catalogs, use DOCUMENT entry.
-D directory, --directory=directory
Search files in directory directory.
-R, --restricted
Restrict file reading (for use in Web apps).
-P literal, --public-id=literal
Print the effective system id for the public id literal.
-S literal, --system-id=literal
Print the effective system id for system id literal.
-p name, --parameter-entity=name
Print the effective system id for parameter entity name.
-d name, --doctype=name
Print the effective system id for the doctype name.
-l name, --linktype=name
Print the effective system id for the linktype name.
-e name, --entity=name
Print the effective system id for entity name.
-n name, --notation=name
Print the effective system id for notation name.
-s name, --declaration=name
Print the effective system id for the SGML declaration for doctype name.
SEE ALSO
onsgmls(1), ospam(1), osgmlnorm(1), ospent(1)
AUTHOR
Ian Castle <ian.castle@openjade.org>
Author.
COPYRIGHT
OpenSP September 2003 OSPCAT(1)