Sponsored Content
Top Forums Shell Programming and Scripting Call Shell Function from mysql timestamp Post 302515576 by DGPickett on Wednesday 20th of April 2011 12:19:09 PM
Old 04-20-2011
Well, to call a shell from a RDBMS engine is tricky, as it runs under the DB id, so be careful.

Maybe you should share the context with us. A hit on a table is a select of any row. If the table is really a view of a sp, the sp can call a udf to do anything you can write, once either for each row or for the whole select. So, you could log to track id's selecting each row or anywhere in the table.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

i want to call a oracle function in my shell script

i want to call a oracle function in my shell script (4 Replies)
Discussion started by: dineshr85
4 Replies

2. Shell Programming and Scripting

how can i call a function in shell script

i have a function written in one shell script and i want to call that function in another shell script and use the value returned by that script. can any one suggest me how can i do that? regards, Rajesh.P (4 Replies)
Discussion started by: rajesh.P
4 Replies

3. UNIX for Dummies Questions & Answers

Creating a function for timestamp in shell script

I have the following code for installing a BSD application stack: #!/bin/sh # install dos2unix and unix2dos utilities echo `date "+%Y-%m-%d %H:%M:%S"` "unix2dos and dos2unix: installing..." >> ~/post_install.log pkg_add -r unix2dos # install xfce4 desktop environment echo `date "+%Y-%m-%d... (3 Replies)
Discussion started by: figaro
3 Replies

4. Shell Programming and Scripting

Shell Script to call another function

Here is the following code : 1. # gcc -c test firstprog.c the above command will generate a executable file called "test " in which ever directory it is run. Assuming It will also return a value. 2. In the below SCRIPT . test is a file generated by compiling a c program... (3 Replies)
Discussion started by: Vabiosis
3 Replies

5. Red Hat

how to call a particular function from one shell another shell script

please help me in this script shell script :1 *********** >cat file1.sh #!/bin/bash echo "this is first file" function var() { a=10 b=11 } function var_1() { c=12 d=13 (2 Replies)
Discussion started by: ponmuthu
2 Replies

6. Shell Programming and Scripting

How to call a function in Shell..?

#!/bin/bash FUN_ECHO(){ echo $1 } FUN_ECHO "hi how are you ?" This code will work fine. BUT is it possible to make the following to work ? FUN_ECHO "hi how are you ?" FUN_ECHO(){ echo $1 } I know that the code will be executed line by line. But i have a number of... (5 Replies)
Discussion started by: linuxadmin
5 Replies

7. Shell Programming and Scripting

Shell Scripting Function call return value

Hi I have a function : Make_Report() { trx_report=`sqlplus -s $conn_str << @@ set echo off; set pages 0; set feedback off; set verify off; select srv_trx_s_no,... (1 Reply)
Discussion started by: neeraj617
1 Replies

8. Shell Programming and Scripting

Segmentation fault in function call, shell script

I am getting Segmentation fault at below function call in my script: get_x() { sqlplus -s / <<end | grep KEEP | sed 's/KEEP//;s///g' select 'KEEP' ,table_name from all_synonyms where upper(synonym_name)= '$1'; exit end x=$(get_x $1) echo " SQL OUTPUT IS :: $x" } I am getting output of... (1 Reply)
Discussion started by: IB_88
1 Replies

9. Shell Programming and Scripting

How to call Oracle function with multiple arguments from shell script?

Dear All, I want to know how can i call oracle function from shell script code . My oracle function have around 5 input parameters and one return value. for name in *.csv; do echo "connecting to DB and start processing '$name' file at " echo "csv file name=$x" sqlplus -s scoot/tiger <!... (2 Replies)
Discussion started by: Balraj
2 Replies

10. Shell Programming and Scripting

Strange function call in the shell script parse_prog_args $@

I am converting shell script to Perl. In shell I have a code parse_prog_args() { if then while do case $1 in -P* | -p* ) export PROCESS_DATE=$2 export MM=`echo $2 | cut -c5-6` export DD=`echo $2 | cut -c7-8` export YY=`echo $2 | cut -c3-4` export... (4 Replies)
Discussion started by: digioleg54
4 Replies
ODBC_SPECIALCOLUMNS(3)							 1						    ODBC_SPECIALCOLUMNS(3)

odbc_specialcolumns - Retrieves special columns

SYNOPSIS
resource odbc_specialcolumns (resource $connection_id, int $type, string $qualifier, string $owner, string $table, int $scope, int $nullable) DESCRIPTION
Retrieves either the optimal set of columns that uniquely identifies a row in the table, or columns that are automatically updated when any value in the row is updated by a transaction. PARAMETERS
o $connection_id -The ODBC connection identifier, see odbc_connect(3) for details. o $type - When the type argument is SQL_BEST_ROWID, odbc_specialcolumns(3) returns the column or columns that uniquely identify each row in the table. When the type argument is SQL_ROWVER, odbc_specialcolumns(3) returns the column or columns in the specified table, if any, that are automatically updated by the data source when any value in the row is updated by any transaction. o $qualifier - The qualifier. o $owner - The owner. o $table - The table. o $scope - The scope, which orders the result set. o $nullable - The nullable option. RETURN VALUES
Returns an ODBC result identifier or FALSE on failure. The result set has the following columns: oSCOPE oCOLUMN_NAME oDATA_TYPE oTYPE_NAME oPRECISION oLENGTH oSCALE oPSEUDO_COLUMN PHP Documentation Group ODBC_SPECIALCOLUMNS(3)
All times are GMT -4. The time now is 07:10 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy