|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Execute an Oracle stored procedure from a shell scrip
Post 73739 by jim mcnamara on Friday 3rd of June 2005 03:17:59 PM
06-03-2005
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Is it possible to pass unix shell arrays in Oracle stored procedure?
Is yes, how?
Thanks (6 Replies)
Discussion started by: superprogrammer
6 Replies
2. Shell Programming and Scripting
hai,
can anybody say how to call or to execute an oracle stored procedure in oracle from unix...
thanks in advance.... for ur reply....
by,
leo (2 Replies)
Discussion started by: Leojhose
2 Replies
3. Shell Programming and Scripting
Hi ,
i have created an .sh file that has the following code:
#!/bin/ksh
sqlplus -s p1istuat/p1istuat@CWS_IST6 @Procedure_Execute.sql &
sqlplus -s p1istuat/p1istuat@CWS_IST6 << EOF
exit
EOF
The mentioned Procedure_Execute.sql file inside has the following code:
exec TEST;
... (5 Replies)
Discussion started by: vins_san
5 Replies
4. Shell Programming and Scripting
Here's a shell script snippet.....
cd $ORACLE_HOME/bin
Retval=`sqlplus -s <<eof
$TPDB_USER/april@$TPD_DBCONN
whenever SQLERROR exit 2 rollback
whenever OSERROR exit 3 rollback
set serveroutput on
set pages 999
var status_desc char(200)
var status_code... (1 Reply)
Discussion started by: hidnana
1 Replies
5. Shell Programming and Scripting
Hi
i am calling a stored procedure from unix shell like this call
test_proc('0002','20100218');
the stored procedure was giving output
like this dbms_output.put_line(' processed earlier');
i want to see the output in the unix shell where i called.
Thanks
barani (6 Replies)
Discussion started by: barani75
6 Replies
6. Shell Programming and Scripting
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;... (6 Replies)
Discussion started by: barani75
6 Replies
7. Shell Programming and Scripting
How to execute the stored procedure from shell script and is there any possibility to print the dbms output in a log file. (2 Replies)
Discussion started by: dineshmurs
2 Replies
8. Shell Programming and Scripting
Hi Gurus,
Want to execute a shell script from a oracle procedure and get the status of the same, any assistance in this regard will be appreciated.
proc_data.sh is script name which I want to execute from oracle procedure
It should work something like below
procedure test
begin... (1 Reply)
Discussion started by: palanisvr
1 Replies
9. Shell Programming and Scripting
Hi,
I am very new to this environment - I hope this is the right platform to discuss my issue:
I created a CRON job to run a Stored Procedure from our database - Sybase.
Within the Stored Procedure there is a TRUNCATE table and CREATE table function.
the CRON job fails to run with... (2 Replies)
Discussion started by: pizzazzz
2 Replies
10. UNIX for Beginners Questions & Answers
Here is the shell script which need to trigger a stored procedure and when the record count is 0 then it should capture in the log that 0 duplicate records are found and if it's more than 0 then log with no of records. Also if there is any sqlerror then it should write the same in the log file and... (17 Replies)
Discussion started by: senmng
17 Replies
LEARN ABOUT NETBSD
fincore
FINCORE(1) BSD General Commands Manual FINCORE(1) NAME
fincore -- query in-core status of file pages SYNOPSIS
fincore [-qs] file ... DESCRIPTION
The fincore utility queries and displays in-core status of specified files. Note that the result can already be stale when being output due to other activities in the system. Thus it should be used only for advisory purposes. The fincore utility accepts the following options. -q The quiet mode. Outputs nothing unless the file has in-core pages. -s The summary mode. Only shows number of pages. EXAMPLES
The following example shows that /bin/cat and /bin/cp are fully cached in-core while the other executables are not in-core. numbers shown in the default output are page indexes in the file of each in-core pages. % fincore /bin/c* /bin/cat: 0 1 2 3 /bin/chio: /bin/chmod: /bin/cp: 0 1 2 3 4 5 /bin/cpio: /bin/csh: % fincore -s /bin/c* /bin/cat: 4 / 4 in-core pages (100.00%) /bin/chio: 0 / 5 in-core pages (0.00%) /bin/chmod: 0 / 3 in-core pages (0.00%) /bin/cp: 6 / 6 in-core pages (100.00%) /bin/cpio: 0 / 36 in-core pages (0.00%) /bin/csh: 0 / 41 in-core pages (0.00%) SEE ALSO
mincore(2) AUTHORS
The fincore utility is written by YAMAMOTO Takashi. CAVEATS
The concept of page cache is an implementation detail of the kernel. The fincore utility works using some assumptions on the current imple- mentation. Thus it might stop working in a future version of NetBSD. BUGS
The amount of CPU time the current implementation of fincore utility would take is roughly proportional to the file sizes. Ideally it should be proportional to the number of in-core pages. BSD
January 5, 2012 BSD