06-17-2008
How to execute an Oracle procedure using shell
no reply??????
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Here is a snippet of my code:
if
then
echo "\n Deleting all reports older than 24 hours. \n" >> $logfile
ls -l $FileName >> $logfile
... (1 Reply)
Discussion started by: mh53j_fe
1 Replies
2. 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
3. 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
4. Shell Programming and Scripting
Hi everyone!
I'm new with Shell Scripting, and I have to do a shell script to call a procedure, which have 2 input parameters, the directory(from server) and the txt file (which have informations to update/insert in DB).
I have to create a shell script to execute that procedure for each txt... (5 Replies)
Discussion started by: renatoal
5 Replies
5. 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
6. 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
7. Shell Programming and Scripting
HI,
i want to write a script (Linux) that:
1) connect to a database oracle
2) execute some store procedure.
Can anybody help me, please?
Thanks a lot
Andrew (3 Replies)
Discussion started by: manichino74
3 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. 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 CENTOS
xcb_randr_get_crtc_gamma_reply
xcb_randr_get_crtc_gamma(3) XCB Requests xcb_randr_get_crtc_gamma(3)
NAME
xcb_randr_get_crtc_gamma -
SYNOPSIS
#include <xcb/randr.h>
Request function
xcb_randr_get_crtc_gamma_cookie_t xcb_randr_get_crtc_gamma(xcb_connection_t *conn, xcb_randr_crtc_t crtc);
Reply datastructure
typedef struct xcb_randr_get_crtc_gamma_reply_t {
uint8_t response_type;
uint8_t pad0;
uint16_t sequence;
uint32_t length;
uint16_t size;
uint8_t pad1[22];
} xcb_randr_get_crtc_gamma_reply_t;
Reply function
xcb_randr_get_crtc_gamma_reply_t *xcb_randr_get_crtc_gamma_reply(xcb_connection_t *conn, xcb_randr_get_crtc_gamma_cookie_t cookie,
xcb_generic_error_t **e);
Reply accessors
uint16_t *xcb_randr_get_crtc_gamma_red(const xcb_randr_get_crtc_gamma_request_t *reply);
int xcb_randr_get_crtc_gamma_red_length(const xcb_randr_get_crtc_gamma_reply_t *reply);
xcb_generic_iterator_t xcb_randr_get_crtc_gamma_red_end(const xcb_randr_get_crtc_gamma_reply_t *reply);
uint16_t *xcb_randr_get_crtc_gamma_green(const xcb_randr_get_crtc_gamma_request_t *reply);
int xcb_randr_get_crtc_gamma_green_length(const xcb_randr_get_crtc_gamma_reply_t *reply);
xcb_generic_iterator_t xcb_randr_get_crtc_gamma_green_end(const xcb_randr_get_crtc_gamma_reply_t *reply);
uint16_t *xcb_randr_get_crtc_gamma_blue(const xcb_randr_get_crtc_gamma_request_t *reply);
int xcb_randr_get_crtc_gamma_blue_length(const xcb_randr_get_crtc_gamma_reply_t *reply);
xcb_generic_iterator_t xcb_randr_get_crtc_gamma_blue_end(const xcb_randr_get_crtc_gamma_reply_t *reply);
REQUEST ARGUMENTS
conn The XCB connection to X11.
crtc TODO: NOT YET DOCUMENTED.
REPLY FIELDS
response_type
The type of this reply, in this case XCB_RANDR_GET_CRTC_GAMMA. This field is also present in the xcb_generic_reply_t and can be
used to tell replies apart from each other.
sequence The sequence number of the last request processed by the X11 server.
length The length of the reply, in words (a word is 4 bytes).
size TODO: NOT YET DOCUMENTED.
DESCRIPTION
RETURN VALUE
Returns an xcb_randr_get_crtc_gamma_cookie_t. Errors have to be handled when calling the reply function xcb_randr_get_crtc_gamma_reply.
If you want to handle errors in the event loop instead, use xcb_randr_get_crtc_gamma_unchecked. See xcb-requests(3) for details.
ERRORS
This request does never generate any errors.
SEE ALSO
AUTHOR
Generated from randr.xml. Contact xcb@lists.freedesktop.org for corrections and improvements.
XCB
2014-06-10 xcb_randr_get_crtc_gamma(3)