How to call sqlloader from stored procedure!!! Advise Post: 302324980

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Oracle stored procedure.

I am using sqlplus. I have the stored procedure name. How can i print the stored procedure content?

2. Shell Programming and Scripting

Need to call stored procedure from unix script

Hi Guys, I have a stored procedure which has 5 out parameters. I need to call the stored procedure from the script. When i use the following in my script, db2 "CALL FCFM.PART_MASTER_TMP($Return_code,$Message,$Message1,$SQL,$Load_count)" >> $LOG_FILE I am getting an error.. Please...

3. Shell Programming and Scripting

need to call 3 stored procedure at the same time

Hi GUYS, I need to trigger 3 stored procedure at the same time.. I know how to trigger the stored procedure. If anybody can tell me how to trigger 3 different process at the same time parallelly.. that would be helpful.. Thanks for your help in advance, Magesh

4. Shell Programming and Scripting

how to call oracle stored procedure from unix shell

Hi i want to call a oracle stored procedure from unix (using bash shell). consider this is my oracle stored procedure with parameter create procedure testproc(name IN varchar, age IN Number, id OUT Number ) AS begin id=1; dbms_output.put.line('successfull validation') end;...

5. Shell Programming and Scripting

Call and redirect output of Oracle stored procedure from unix script

Hi, Can you assist me in how to redirect the output of oracle stored procedure from unix script? Something similar to what i did for sybase isql -U$MYDBLOG -D$MYDBNAME -S$MYDBSVR -P$MYDBPWD -o$MYFILE<< %% proc_my_test 8 go %% Thanks in advance - jak

6. Shell Programming and Scripting

How to create and call mysql stored procedure in perl?

Hi, I want to create MySQL stored procedure and call the stored procedure using perl. I tried like this: use DBI; my $dbh = DBI->connect ("DBI:mysql:test", "root", "ibab", { RaiseError => 1, PrintError => 0}); $create_procedure =...

7. Shell Programming and Scripting

How to call a stored procedure from shell program?

How to call a stored procedure from shell program

8. Shell Programming and Scripting

How to call stored procedure with CLOB out parameter from shell script?

I have written a stored procedure in oracle database, which is having a CLOB OUT parameter. How can i call this stored procedure from shell script and get the CLOB object in shell script variable?

9. Shell Programming and Scripting

Stored Procedure not executing

below code is not executing the stored procedure,not sure what the issue.Even sqllog is blank.please help me its very urgent. sqlplus -s $connect_str@$DB_ORACLE_SID >> ${SQL_LOG_FILE} << EOF set serverout on set feed off set head off set pages 0 set colsep , set tab off set lin 150...

10. Shell Programming and Scripting

How to call a stored procedure inside a loop?

How to call a stored procedure inside a loop export PATH=$ORACLE_HOME/bin:$PATH ORACLE_SID=xxxx; export ORACLE_SID ORAENV_ASK=NO TODAY_DATE=$(date +"%Y%m%d") LOGFILE=/var/opt/gogd/cust/scripts/${TODAY_DATE}_sap_cust_rel.log echo 'Connected' PARCUST=sap_cust_rel.par sqlldr...

LEARN ABOUT NETBSD

ching

CHING(6)							 BSD Games Manual							  CHING(6)

NAME

     ching -- the book of changes and other cookies

SYNOPSIS

     ching [hexagram]

DESCRIPTION

     The I Ching or Book of Changes is an ancient Chinese oracle that has been in use for centuries as a source of wisdom and advice.

     The text of the oracle (as it is sometimes known) consists of sixty-four hexagrams, each symbolized by a particular arrangement of six
     straight (---) and broken (- -) lines.  These lines have values ranging from six through nine, with the even values indicating the broken
     lines.

     Each hexagram consists of two major sections.  The Judgement relates specifically to the matter at hand (e.g., ``It furthers one to have
     somewhere to go.'') while the Image describes the general attributes of the hexagram and how they apply to one's own life (``Thus the
     superior man makes himself strong and untiring.'')

     When any of the lines have the values six or nine, they are moving lines; for each there is an appended judgement which becomes significant.
     Furthermore, the moving lines are inherently unstable and change into their opposites; a second hexagram (and thus an additional judgement)
     is formed.

     Normally, one consults the oracle by fixing the desired question firmly in mind and then casting a set of changes (lines) using yarrow-stalks
     or tossed coins.  The resulting hexagram will be the answer to the question.

     Using an algorithm suggested by S. C. Johnson, the UNIX oracle simply reads a question from the standard input (up to an EOF) and hashes the
     individual characters in combination with the time of day, process id and any other magic numbers which happen to be lying around the system.
     The resulting value is used as the seed of a random number generator which drives a simulated coin-toss divination.  The answer is then piped
     through nroff(1) for formatting and will appear on the standard output.

     For those who wish to remain steadfast in the old traditions, the oracle will also accept the results of a personal divination using, for
     example, coins.  To do this, cast the change and then type the resulting line values as an argument.

     The impatient modern may prefer to settle for Chinese cookies; try fortune(6).

DIAGNOSTICS

     The great prince issues commands,

     Founds states, vests families with fiefs.

     Inferior people should not be employed.

SEE ALSO

     It furthers one to see the great man.

BUGS

     Waiting in the mud

     Brings about the arrival of the enemy.

     If one is not extremely careful,

     Somebody may come up from behind and strike him.

     Misfortune.

BSD
								   May 31, 1993 							       BSD