Sponsored Content
Full Discussion: Error sqlloader
Top Forums Shell Programming and Scripting Error sqlloader Post 302575404 by Rodrih92 on Monday 21st of November 2011 02:21:23 PM
Old 11-21-2011
Error sqlloader

Hello I am having a problem with a script. I try to run a store procedure from unix with sqlldr and shows me the following error.

Code:
begin
*
ERROR at line 1:
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "RNP.SP_ARCH_SALIDA", line 64
ORA-06512: at line 2



The sp creates a data file with a table. Run the script as a parameter by sending the directory where you saved the file. If I taste the TOAD enviendole sp from the directory as a parameter showing the script, works and creates the file


Script:

Code:
work=/work/input/telefonia
BASE=rnp/rnp@sinti9d

. profile.sinti9d

sqlplus -s $BASE <<EOF
set serveroutput on
spool salida.txt
begin
sp_arch_salida('/work/input/telefonia/prueba');
end;
/
spool off
EOF


From already thank you very much

Last edited by pludi; 11-21-2011 at 03:50 PM..
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

awk Shell Script error : "Syntax Error : `Split' unexpected

hi there i write one awk script file in shell programing the code is related to dd/mm/yy to month, day year format but i get an error please can anybody help me out in this problem ?????? i give my code here including error awk ` # date-month -- convert mm/dd/yy to month day,... (2 Replies)
Discussion started by: Herry
2 Replies

2. Shell Programming and Scripting

sqlloader issue

Hi All, I am using sqlloader in my shellscript.pastimg my code below sqlldr XXXXXX/XXXXXXX@10.58.111.121:1221/XXXX control=/root/tracking/load.ctl log=sqlloaderlogs.log I have 3 questions .. 1) how can i avoid printing the sqlloader operations messages in my screen while running. 2) How... (1 Reply)
Discussion started by: subin_bala
1 Replies

3. Shell Programming and Scripting

runing shell with java and sqlloader issue

Hello there, I'm writing a shellscript and it uses sqlloader, it works good coz load the data into the DB. But I'm runing the shell from a java program with Runtime(). It does execute the shell but the sqlloader doesn't seem to be working!! Does anybody out there knows why?? (0 Replies)
Discussion started by: ying_dav
0 Replies

4. AIX

nim mksysb error :/usr/bin/savevg[33]: 1016,07: syntax error

-------------------------------------------------------------------------------- Hello, help me please. I am trying to create a mksysb bakup using nim. I am geting this error, how to correct it ? : Command : failed stdout: yes stderr: no... (9 Replies)
Discussion started by: astjen
9 Replies

5. Programming

How to call sqlloader from stored procedure!!! Advise

Hi , I have a dellimited .dat file and a sqlloader. I want to call the sqlloader from a oracle stored procedure. The procedure should return the result of sqlloader's execution. (3 Replies)
Discussion started by: Haque123
3 Replies

6. Shell Programming and Scripting

Use a shell variable value in a control file via sqlloader

Dear, I must load a file in a table via sqlloader. I have also a column in this table which must contain the same value for all rows in this table. And this value is get from a shell script variable. Can you give me a sort example on how to use a shell script variable as a paramter in a CTL... (1 Reply)
Discussion started by: yeclota
1 Replies

7. UNIX for Dummies Questions & Answers

> 5 ")syntax error: operand expected (error token is " error

im kinda new to shell scripting so i need some help i try to run this script and get the error code > 5 ")syntax error: operand expected (error token is " the code for the script is #!/bin/sh # # script to see if the given value is correct # # Define errors ER_AF=86 # Var is... (4 Replies)
Discussion started by: metal005
4 Replies

8. Programming

eliminate duplicate rows - sqlloader

Hi , I have a data file in this format. p1 p2 p3 10 0 10 0 1000 I am using a sqlloader script to load the data into the database table.There is a unique constraint on the columns p1 and p2. So, sqlldr cannot load both the records. This eliminates duplicate records from being... (1 Reply)
Discussion started by: megha2525
1 Replies

9. Solaris

Rpcinfo: can't contact portmapper: RPC: Authentication error; why = Failed (unspecified error)

I have two servers with a fresh install of Solaris 11, and having problems when doing rpcinfo between them. There is no firewall involved, so everything should theoretically be getting through. Does anyone have any ideas? I did a lot of Google searches, and haven't found a working solution yet. ... (2 Replies)
Discussion started by: christr
2 Replies

10. UNIX for Beginners Questions & Answers

Print Error in Console and both Error & Output in Log file - UNIX

I am writing a shell script with 2 run time arguments. During the execution if i got any error, then it needs to redirected to a error file and in console. Also both error and output to be redirected to a log file. But i am facing the below error. #! /bin/sh errExit () { errMsg=`cat... (1 Reply)
Discussion started by: sarathy_a35
1 Replies
ERROR::PASS1(7stap)													       ERROR::PASS1(7stap)

NAME
error::pass1 - systemtap pass-1 errors DESCRIPTION
Errors that occur during pass 1 (parsing) usually mean a basic syntax error of some sort occurred in the systemtap script. There are sev- eral classes of problems possible: plain syntax error The systemtap script parser detects a large variety of errors, such as missing operands, bad punctuation. It tries to list what kinds of tokens it was expecting to see, and will show the region of the source code with the problem. Please review the stap(1) man page and/or the tutorial, to correct the script's syntax. grammar ambiguities There is at least one known ambiguity in the systemtap grammar. It relates to the optionality of ; (semicolon) separators between statements, and the ++ and -- increment/decrement operators. If the parser indicates an error, consider adding some explicit ; sep- arators between nearby statements and try again. missing command line arguments A systemtap script that uses the $N and @N constructs for substituting in command-line options may fail if not enough options were given on the stap command line. compatibility changes Some versions of systemtap have changed the language incompatibly, for example by adding the try/catch keywords for exception han- dling. In such cases, rerun systemtap with the --compatibility=VERSION option, substituting the last systemtap version where your script was known to work. You may also check the release-history NEWS file for compatibility changes. GATHERING MORE INFORMATION
Increasing the verbosity of pass-1 with an option such as --vp 1 can help pinpoint the problem. SEE ALSO
stap(1), error::reporting(7stap) ERROR::PASS1(7stap)
All times are GMT -4. The time now is 12:56 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy