10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi All,
I am running the below proc in unix by connecting through sqlplus and the procedure is completing successfully. But when i am trying to run through shell scripting by using function. I am getting the error as follows. Please guide me where I am going wrong.
#!/bin/sh
opera ()
{... (6 Replies)
Discussion started by: bhas85
6 Replies
2. Shell Programming and Scripting
Hi Gurus,
The following script fails with the error 'command not found' while trying to execute. As the error indicates, the script fails at ROW#30 where the EOF is defined for SQL statement.
It appears that the script is trying execute the lines in the SQL output written to ta spool file.... (7 Replies)
Discussion started by: svajhala
7 Replies
3. Shell Programming and Scripting
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... (3 Replies)
Discussion started by: katakamvivek
3 Replies
4. Shell Programming and Scripting
Hi,
I want to have a automted script to exceute 20 procedures one by one.
Suppose below is one procedure once it get executed script will write
"PL/SQL procedure successfully completed." to a log
for ex-
exec dbms_stats.gather_table_stats();
Now later procedure starts executing... (1 Reply)
Discussion started by: sv0081493
1 Replies
5. Shell Programming and Scripting
Hello,
I created a sql file to create a Procedure, and it was successfully created.
I created a sql file to execute the procedure, and it did without any errors, but i dont see the data been updated.
The Execute procedure.sql script is:
BEGIN
set serveroutput on size 1000000
execute... (5 Replies)
Discussion started by: msrahman
5 Replies
6. Linux
Hi,
I have following shell script code :
------------------------------------------------------------------
#!/bin/bash
SCRIPTS_DIR="/scriptsDir1"
# tables login/password
APIL_USER="uname/pswd"
I2_USER="uname/pswd"
# Database
DB="db1"
cd "$SCRIPTS_DIR/scriptsDir2"
sqlplus... (1 Reply)
Discussion started by: Chaitrali
1 Replies
7. Shell Programming and Scripting
Hi,
I have following shell script code :
------------------------------------------------------------------
#!/bin/bash
SCRIPTS_DIR="/scriptsDir1"
# tables login/password
APIL_USER="uname/pswd"
I2_USER="uname/pswd"
# Database
DB="db1"
cd "$SCRIPTS_DIR/scriptsDir2"
sqlplus... (2 Replies)
Discussion started by: Chaitrali
2 Replies
8. Shell Programming and Scripting
Hi Gurus,
I've a find command that gets the list of files from a source directory where the extension is not html, xml, jsp, shtml or htaccess. The below find command runs fine from the command prompt or in a shell script. I need to eventually run it in a PERL script and am getting the... (5 Replies)
Discussion started by: voorkey
5 Replies
9. Shell Programming and Scripting
Hi Guys,
I am trying to tun a oracle proedure throgh unix shell script but it is not running i dont know why ? i have tested this procedure in sqlplus and it was working fine.
can you see the script and sql file and let me know where is my mistake.
script:bm_chart_table_loading.sh
... (3 Replies)
Discussion started by: shary
3 Replies
10. Shell Programming and Scripting
Hi All,
When I am trying to execute the below shell script I got this error message.
script
==========
#!/bin/bash
/usr/java/jdk1.5.0_10/bin/java - classpath /var/lib/asterisk/agi-bin/mysql-connector-java-3.0.15-ga-bin.jar/:
/var/lib/asterisk/agi-bin/jarfiles:... (4 Replies)
Discussion started by: ajayyaduwanshi
4 Replies
XConnectionWatchProc(3X) XLIB FUNCTIONS XConnectionWatchProc(3X)
NAME
XConnectionWatchProc - procedure called when internal connection opens or closes
SYNTAX
typedef void (*XConnectionWatchProc)(display, client_data, fd, opening, watch_data)
Display *display;
XPointer client_data;
int fd;
Bool opening;
XPointer *watch_data;
ARGUMENTS
display Specifies the connection to the X server.
client_data
Specifies the additional client data.
fd Specifies the file descriptor.
opening Specifies whether the connections is being opened or closed.
watch_data
Specifies a location for private watch_data.
DESCRIPTION
XConnectionWatchProc is registered by XAddConnectionWatch() and is called each time Xlib opens or closed an internal connection for the
specified display.
If opening is True, the procedure can store a pointer to private data in the location pointed to by watch_data; when the procedure is later
called for this same connection and opening is False, the location pointed to by watch_data will hold this same private data pointer.
The registered procedure should not call any Xlib functions. If the procedure directly or indirectly causes the state of internal connec-
tions or watch procedures to change, the result is not defined. If Xlib has been initialized for threads, the procedure is called with the
display locked and the result of a call by the procedure to any Xlib function that locks the display is not defined unless the executing
thread has externally locked the display using XLockDisplay.
SEE ALSO
XAddConnectionWatch(3X)
X Version 11 Release 6 XConnectionWatchProc(3X)