07-01-2010
Thanks a lot, but it wasn't very useful. I know that the script is very simple, but i don't know Linux. The script must:
1) connect to sqlplus
2) execute my store procedures
Thanks a lot
Andrew
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi, can someone point out the tutorial or syntax for how to execute store procedure through shell scripting .
thanks. (7 Replies)
Discussion started by: epall
7 Replies
2. Shell Programming and Scripting
hi,
this is urgent..can i run a shell script from store procedure without using java. (8 Replies)
Discussion started by: arnabb4u
8 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
hi
i am calling a oracle stored procedure(in the database) from unix shell scripting (a.sh).
the called stored procedure returns some values through OUT variables
i want to assign the return values of stored procedure in to unix shell script variable.
can you provide me the code.
... (1 Reply)
Discussion started by: barani75
1 Replies
5. 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
6. Shell Programming and Scripting
Hi Friends,
I am using AIX version and sqlplus to connect to database while writing a shell script.
I have implemented three ways to connect to database :
1)
sqlplus -s <USERNAME>/<PASSWORD> <<!
@<SQL FILE TO EXECUTE>
exit
!
2)
sqlplus -s <USERNAME>/<PASSWORD> <<!
-----sql statemenets... (6 Replies)
Discussion started by: gauravgarg
6 Replies
7. Shell Programming and Scripting
Hi,
I have a sybase stored procedure which takes two input parameters (start_date and end_date) and when it get executed, it gives few records as an output.
I want to write a unix script (ksh) which login to the sybase database, then execute this stored procedure (takes the input parameter as... (8 Replies)
Discussion started by: amit.mathur08
8 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
i have the following code inside a shell script .prog in oracle server when i call the program
DBMS_OUTPUT.PUT_LINE(x_return_status|| ln_rep_req_id);
will return 0 , it is very strange , i try to submit the concurrent request in oracle , and it can successfully executed, what am i missing ? i... (1 Reply)
Discussion started by: feilhk
1 Replies
10. AIX
I have a requirement and below is the detail.
Create a shell script and needs to run in server "a".
Connect to teradata database server "b".
execute the .sql file from server "a"
Save the output of the query to a file in server "a"
Schedule this shell script to run every day for every 4... (1 Reply)
Discussion started by: MadhuSeven
1 Replies
LEARN ABOUT PHP
ingres_fetch_proc_return
INGRES_FETCH_PROC_RETURN(3) 1 INGRES_FETCH_PROC_RETURN(3)
ingres_fetch_proc_return - Get the return value from a procedure call
SYNOPSIS
int ingres_fetch_proc_return (resource $result)
DESCRIPTION
This function is used to retrieve the return value following the execution of an Ingres database procedure (stored procedure).
Note
If used with a row-producing procedure, this function should be called after all the rows from the procedure have been fetched
using ingres_fetch_array(3), ingres_fetch_object(3) or ingres_fetch_row(3). This function will eliminate any rows yet to be fetched
should there be any left over.
PARAMETERS
o $result
- The result identifier for a query
RETURN VALUES
Returns an integer if there is a return value otherwise it will return NULL.
EXAMPLES
Example #1
Get the return value from a procedure call
<?php
$link = ingres_connect($database);
if ( ingres_errno() != 0 ) {
$error_text = ingres_error();
die($error_text);
}
$result = ingres_query($link, "execute procedure php_proc (value = 1000)");
if ( ingres_errno() != 0 ) {
$error_text = ingres_error();
die($error_text);
}
echo "return value - " . ingres_fetch_proc_return($result) . "
";
ingres_close($link);
?>
SEE ALSO
ingres_query(3), ingres_fetch_array(3), ingres_fetch_object(3), ingres_fetch_row(3).
PHP Documentation Group INGRES_FETCH_PROC_RETURN(3)