Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Insert script result into Oracle Table
Top Forums Shell Programming and Scripting Insert script result into Oracle Table Post 302748047 by vichuelaa on Monday 24th of December 2012 08:07:21 AM
Old 12-24-2012
Insert into oracle table
Hi Scott,

I am getting below error.

Quote:
Originally Posted by Scott
Code:
ORACLE_SID=<db name>
ORAENV_ASK=NO
. /usr/local/bin/oraenv
 
for i in ....
...
sqlplus /nolog << !
  connect user/pass
  insert into tbl_daily_status values('$STAT','$ENDTIME');
!
...
done



Code:
"batch.sh" 42 lines, 497 characters 
PaBatchd_234>>batch.sh
FA
09/28/2012 03:05:22
SU
09/07/2012 05:56:51
RU
----- -----
RU
----- -----

batch.sh[13]: syntax error at line 14 : `newline or ;' unexpected
PaBatchd_234>>
Last edited by Scott; 12-24-2012 at 09:28 AM.. Reason: Code tags
 

10 More Discussions You Might Find Interesting

1. Programming

How can i load or insert a table in oracle from c language thru unix environment

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

2. UNIX for Advanced & Expert Users

unix script for update or insert records from a file to a oracle table

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

3. Shell Programming and Scripting

Insert value to ORACLE table from sqlldr log

This is the sample sqlldr log: ------------------------------------------------------------------------------------------------------------ SQL*Loader: Release 9.2.0.7.0 - Production on Sun Feb 8 23:37:02 2009 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Control... (13 Replies)
Discussion started by: aimy
13 Replies

4. Shell Programming and Scripting

select values from db1 table and insert into table of DB2

Hi I am having three oracle databases running in three different machine. their ip address is different. from one of the DB am able to access both the databases.(means am able to select values and insert values in to tables individually.) I need to fetch some data from DB1 table(say DB1 ip is... (2 Replies)
Discussion started by: aemunathan
2 Replies

5. Shell Programming and Scripting

Insert into Oracle table thru UNIX - linux 2.6.9-89

Hi, I am trying to insert a record into a table (say dips_tbl) which resides in Oracle DB through a ksh script. I want to insert records into few of the table columns-not all. I'll give an e.g. for the date column "CREATE_DATE". For that I first execute SQL1="SELECT SYSDATE FROM DUAL" ... (1 Reply)
Discussion started by: dips_ag
1 Replies

6. UNIX for Dummies Questions & Answers

Bash script to insert data into an html table

hi, I need to create a bash shell script which picks up data from a text file and in the output file puts it into an html made table. I have to use sed and awk utilties to do this the input text file will contain data in the format: job name para1 para2 para3 para4 para4 1 ... (1 Reply)
Discussion started by: intern123
1 Replies

7. Shell Programming and Scripting

Bash script to display result in table

My script gives the following result. Is it possible to display the same in table format ? 1. rex_best Latest feeds are not avaialable. The last feed was generated on 2012-05-17 File Name = ekb_best_20120517_010949_665.tar.gz The Number of entry elements = 4209539 2. rex_genre Latest... (2 Replies)
Discussion started by: kishorekumar87
2 Replies

8. Shell Programming and Scripting

Intelligent Script to Insert Records in Database Table

Hello All Members, I am new to this forum and to the shell scripting. I want to write a shell script to do the following: Scenario: I have a pipe delimited .txt file with multiple fields in it. The very first row of the file contains the name of the column which resembles the name of the... (18 Replies)
Discussion started by: chetanojha
18 Replies

9. Shell Programming and Scripting

Python Script to take file count and insert into DB2 table

Team I have files in different directories . How can i take the count of latest file and insert into Db2 table . I am using awk 'END{print NR+1-ARGC}' (File name) to get the counts. How can i take 1.The count of latest file 2.Insert into Db2 table( File Name and Counts) . cd... (4 Replies)
Discussion started by: Perlbaby
4 Replies

10. UNIX for Beginners Questions & Answers

Help on Oracle insert from shell script

Hi All I am trying to create a shell script to insert in to oracle table so far insert happens with out an issue, but i cant pass message variable to sqlplus script insert. i have highlighted the variable in red. Please help. thanks in advance. #!/bin/sh df -H | grep -vE... (3 Replies)
Discussion started by: LPK
3 Replies

LEARN ABOUT DEBIAN

ns_job

ns_job(3aolserver)					    AOLserver Built-In Commands 					ns_job(3aolserver)

__________________________________________________________________________________________________________________________________________________

NAME

       ns_job - commands

SYNOPSIS

       ns_job option ?arg arg ...?

       ns_job create ?-desc description? queueId ?maxthreads?

       ns_job queue ?-detached? queueId  script

       ns_job wait ?-timeout seconds:microseconds? queueId  jobId

       ns_job waitany ?-timeout seconds:microseconds? queueId

       ns_job cancel queueId jobId

       ns_job delete queueId

       ns_job jobs queueId

       ns_job queues

       ns_job threadlist

       ns_job queuelist

       ns_job joblist

       ns_job genid

_________________________________________________________________

DESCRIPTION

       ns_job manages a thread pool and a set of named "queues". Queues have a max number of threads and when the current number of running thread
       reaches "max" then jobs are queued.

       New threads are created when there are less than  maxthread  number of idle threads.

OPTIONS

       create

	      create ?-desc description? queueId ?maxthreads?

	      Create a new job queue called queueId. If maxthreads is not specified, then the default of 4 is used.

       queue

	      queue ?-detached? queueId script

	      Add a new job to the queue. If there are less than maxthreads current running then the job will be started. If there are	maxthreads
	      currently running then this new job will be queued.

	      If detached is true, then the job will be cleaned up when it completes; no wait will be necessary.

	      The new job's ID is returned.

       wait

	      wait ?-timeout seconds:microseconds? queueId jobId

	      Wait for the specified queued or running job to finish. wait returns the results of the script.

	      An error is thrown if the specified timeout period is reached.

       waitany

	      waitany ?-timeout seconds:microseconds? queueId

	      Wait for any job on the queue complete.

	      An error is thrown if the specified timeout period is reached.

       cancel

	      cancel queueId jobId

	      Remove  the  specified job from the queue. If the job is currently running, then the job will be removed from the queue when it com-
	      pletes.

	      1 (true)	is returned if the job is currently running and can not be cancelled.

       delete

	      delete queueId

	      Request that the specified queue be deleted. The queue will only be deleted when all jobs are removed.

       jobs

	      jobs queueId

	      Return a list of the job IDs.

       queues

	      Returns a list of the queues IDs.

       threadlist

	      Returns a list of the thread pool's fields.

	      maxthreads
		     Max number of threads for all the queues in the thread pool.

	      numthreads
		     Number of allocated threads.

	      numidle
		     Number of currently idle threads.

	      req
		     stop
			    The thread pools is being stopped. This probably means that the server is shutting down.

       queuelist

	      Returns a list of the queues. A queue has the following fields:

	      name
		     Name of the queue.

	      desc
		     Description of the queue.

	      maxthreads
		     Max number of threads to run for this queue.

	      numrunning
		     Number of currently running jobs in this queue.

	      REQ
		     delete
			    Someone requested this queue be deleted. Queue will not be deleted until all the jobs on the queue are removed.

       joblist

	      Returns a list the jobs in the specified queue. A job has the following fields:

	      id
		     Job's ID

	      state
		     scheduled
			    The job is schedule to run.
		     running
			    The job is currently running.
		     done
			    The job is has completed.

	      results
		     If the job has completed, then this field will contain the results. If the job is running or scheduled to run, then this will
		     contain the script.

	      code
		     When the job is done, this will contain the return code.
			    Codes
				    TCL_OK
				    TCL_ERROR
				    TCL_RETURN
				    TCL_BREAK
				    TCL_CONTINUE

	      TYPE
		      nondetached
		      detached

	      REQ
		      none
		      wait
		      cancel

       genid

	      Generate a new unique ID. This new ID can be used as the queue ID without conflicting with any other queue ID.

BUGS

SEE ALSO

       nsd(1), info(n)

KEYWORDS

       ns_job

AOLserver								4.0							ns_job(3aolserver)
All times are GMT -4. The time now is 06:09 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy