10-11-2012
Yes, that one would be.
Hardcode your own simple one with fixed connection details and it won't be vulnerable to injection.
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi-
I am trying to achieve the following in a script so I can schedule it on a cron job. I am fairly new to the unix environment...
I have written a shell script that reads a flat file and loads the data into an Oracle table (Table1) via SQLLDR. This Works fine. Then, I run a nested insert... (5 Replies)
Discussion started by: rajagavini
5 Replies
2. UNIX for Dummies Questions & Answers
Hi Guys,
I wanted to check the sql connection through scripting if it is avilable then proceed else stop the process
I was trying
sqlplus -L username/passwd@sid
if this is not sucess it gives non-zero.
but if it is success it is going into the sqlplus prompt.
So how could i get out... (2 Replies)
Discussion started by: Swapna173
2 Replies
3. Shell Programming and Scripting
How do I dynamically assign the below output to unix shell variables
so I can build a menu in a shell script?
Example:
var1 = 1 var2= SYSTEM
var3 = 2 var4= UNDOTBS1
and so on, then in the shell script I can use the variables to build a menu.
set serveroutput on
declare... (2 Replies)
Discussion started by: djehres
2 Replies
4. UNIX for Dummies Questions & Answers
Hi guys,
I am new on here, I have a function in oracle that returns a specific value:
create or replace
PACKAGE BODY "CTC_ASDGET_SCHED" AS
FUNCTION FN_ASDSCHEDULE_GET
RETURN VARCHAR2
AS
BEGIN
DECLARE
ASDSchedule varchar2(6);
ASDComplete... (1 Reply)
Discussion started by: reptile
1 Replies
5. Shell Programming and Scripting
Hi!
I would like to do a single connection to sqlplus and execute some querys.
Actually I do for every query one connection to database
i.e
echo 'select STATUS from v$instance;
exit' > $SQL_FILE
sqlplus user/pass@sid @$SQL_FILE > $SELECT_RESULT
echo 'select VERSION from v$instance;... (6 Replies)
Discussion started by: guif
6 Replies
6. UNIX for Advanced & Expert Users
Hi Experts:
I have a shell script that's kicked off by cron. Inside this shell script, I need to kick off two or more oracle sql scripts to process different groups of tables. And when both sql scripts are done, I will continue in the shell script to do other things like checking processing... (3 Replies)
Discussion started by: huasheng8
3 Replies
7. Shell Programming and Scripting
Hello,
I have two .sql files which I transferred from Windows to Unix (Linux Enterprise Linux Server release 5.3).I want to ensure that these two files have no junk characters in them.How do I do it in the simplest possible way?
Many thanks
DJ (1 Reply)
Discussion started by: Digjoy83
1 Replies
8. Shell Programming and Scripting
I use below command to log in to oracle database
sqlplus username/passwordWhen i enter into sql prompt i press quitIf there are any errors it will show just below the output of sqlplus username/password. The errors generally start with keyword ORA can we do this by using a unix shell script.?... (4 Replies)
Discussion started by: Nakul_sh
4 Replies
9. Shell Programming and Scripting
Hi All,
I want to run multiple sql queries and store the data in variable but i want to use sql command only once. Is there a way without running sql command twice and storing.Please advise.
Eg :
Select 'Query 1 output' from dual;
Select 'Query 2 output' from dual;
I want to... (3 Replies)
Discussion started by: Rokkesh
3 Replies
LEARN ABOUT PHP
mysqlnd_memcache_set
MYSQLND_MEMCACHE_SET(3) 1 MYSQLND_MEMCACHE_SET(3)
mysqlnd_memcache_set - Associate a MySQL connection with a Memcache connection
SYNOPSIS
bool mysqlnd_memcache_set (mixed $mysql_connection, [Memcached $memcache_connection], [string $pattern], [callback $callback])
DESCRIPTION
Associate $mysql_connection with $memcache_connection using $pattern as a PCRE regular expression, and $callback as a notification call-
back or to unset the association of $mysql_connection.
While associating a MySQL connection with a Memcache connection, this function will query the MySQL Server for its configuration. It will
automatically detect whether the server is configured to use the InnoDB Memcache Daemon Plugin or MySQL Cluster NDB Memcache support. It
will also query the server to automatically identify exported tables and other configuration options. The results of this automatic config-
uration can be retrieved using mysqlnd_memcache_get_config(3).
PARAMETERS
o $mysql_connection
- A handle to a MySQL Server using one of the MySQL API extensions for PHP, which are PDO_MYSQL, mysqli or ext/mysql.
o $memcache_connection
- A Memcached instance with a connection to the MySQL Memcache Daemon plugin. If this parameter is omitted, then $mysql_connection
will be unassociated from any memcache connection. And if a previous association exists, then it will be replaced.
o $pattern
- A regular expression in Perl Compatible Regular Expression syntax used to identify potential Memcache-queries. The query should
have three sub patterns. The first subpattern contains the requested field list, the second the name of the ID column from the
query and the third the requested value. If this parameter is omitted or os set to NULL, then a default pattern will be used.
o $callback
- A callback which will be used whenever a query is being sent to MySQL. The callback will receive a single boolean parameter
telling if a query was sent via Memcache.
RETURN VALUES
TRUE if the association or disassociation is successful, otherwise FALSE if there is an error.
EXAMPLES
Example #1
mysqlnd_memcache_set(3) example with var_dump(3) as a simple debugging callback.
<?php
$mysqli = new mysqli("host", "user", "passwd", "database");
$memc = new Memcached();
$memc->addServer("host", 11211);
mysqlnd_memcache_set($mysqli, $memc, NULL, 'var_dump');
/* This query will be intercepted and executed via Memcache protocol */
echo "Sending query for id via Memcache: ";
$mysqli->query("SELECT f1, f2, f3 FROM test WHERE id = 1");
/* f1 is not configured as valid key field, this won't be sent via Memcache */
echo "Sending query for f1 via Memcache: ";
$mysqli->query("SELECT id FROM test WHERE f1 = 1");
mysqlnd_memcache_set($mysqli);
/* Now the regular MySQL protocol will be used */
echo "var_dump won't be invoked: ";
$mysqli->query("SELECT f1, f2, f3 WHERE id = 1");
?>
The above example will output:
Sending query for id via Memcache: bool(true)
Sending query for f1 via Memcache: bool(false)
var_dump won't be invoked:
SEE ALSO
mysqlnd_memcache_get_config(3).
PHP Documentation Group MYSQLND_MEMCACHE_SET(3)