01-08-2008
Thanks!
While I am sure your solution works perfectly, I was able to work around the problem by changing my SQL that produces the difference between last id and max id and output 'true' if there is a difference. Now I just need to grep on true from the sqlplus.out file and that satisfies the condition.
As always unix.com delivers, in my case not a final solution, but helpful hints to get me there.
9 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi gurus.
I wonder if there is some command that will help me to determing the progress of cp. I'm copying huge amount of files, and through the
ps x -uoracle see, that it goes
1771 pts/6 S+ 0:37 cp 1_2600_617913793.arc
37 minutes. Is there command, that helps determing on what... (0 Replies)
Discussion started by: MarGur
0 Replies
2. Shell Programming and Scripting
How do i go about getting the uid of the user and verify ?
if
then
echo "You are not a superuser, please login as a superuser"
exit1;
fi
the above code doesn't work. can some guru please help me.
1. how to get the uid of the user ? i know by typing id but how to... (7 Replies)
Discussion started by: filthymonk
7 Replies
3. Shell Programming and Scripting
hi ,
i am having one file which is having the contents like this :
"1111111111"
"2222222222"
"4444232344"
...
i want to check if all the patterns in the file follows this sequence like starting with " ending with " inside that 10 digits...
can anyone help me in checking that..
... (5 Replies)
Discussion started by: kripssmart
5 Replies
4. UNIX for Dummies Questions & Answers
I was wondering if there is a way to to check if two files are the same. I've tried writing a script called samefile, which takes in two arguments (files) and attempts to compare them to see if they're the same file.
Here is what I have so far:
if
then
echo "The two files are not the... (0 Replies)
Discussion started by: Trinimini
0 Replies
5. UNIX for Dummies Questions & Answers
I was wondering if there is a way to to check if two files are the same. I've tried writing a script called samefile, which takes in two arguments (files) and attempts to compare them to see if they're the same file.
Here is what I have so far:
if
then
echo "The two files are not the... (4 Replies)
Discussion started by: Trinimini
4 Replies
6. Shell Programming and Scripting
I shoe here the start of a csh script I have written. I am trying to write some code to check the arguments and if the arguments don't match the tags, I will abort and display an error.
For example using
./script.csh -r=10/20.30/40 -xyz=2/3/4
will give an error as the -xyz tag doea not... (24 Replies)
Discussion started by: kristinu
24 Replies
7. Homework & Coursework Questions
Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted!
1. The problem statement, all variables and given/known data:
What the program is suppose to do is input a word and when the user press enter the result should read the word... (6 Replies)
Discussion started by: mgyeah
6 Replies
8. Shell Programming and Scripting
Hi
I have 4 files, I need the check whether these 4 files are having header and Trailer records. header and trailer records are identified with 1,b. If any file is not having these we will not proceed with other process.
Output should be 1 if all files are having header and footer other... (4 Replies)
Discussion started by: cnrj
4 Replies
9. SCO
Hi, (i'm sorry for my english)
I'm a problem on boot sco unix 5.0.5 open server.
this stop at "Checking protected password and checking subsystem databases"
(See this image )
I'm try this:
1) http://www.digipedia.pl/usenet/thread/50/37093/#post37094
2) SCO: SCO Unix - Server hangs... (9 Replies)
Discussion started by: buji
9 Replies
LEARN ABOUT PHP
oci_set_action
OCI_SET_ACTION(3) OCI_SET_ACTION(3)
oci_set_action - Sets the action name
SYNOPSIS
bool oci_set_action (resource $connection, string $action_name)
DESCRIPTION
Sets the action name for Oracle tracing.
The action name is registered with the database when the next 'roundtrip' from PHP to the database occurs, typically when an SQL statement
is executed.
The action name can subsequently be queried from database administration views such as V$SESSION. It can be used for tracing and monitor-
ing such as with V$SQLAREA and DBMS_MONITOR.SERV_MOD_ACT_STAT_ENABLE.
The value may be retained across persistent connections.
PARAMETERS
o $connection
-An Oracle connection identifier, returned by oci_connect(3), oci_pconnect(3), or oci_new_connect(3).
o $action_name
- User chosen string up to 32 bytes long.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
Setting the action
<?php
$c = oci_connect('hr', 'welcome', 'localhost/XE');
// Record the action
oci_set_action($c, 'Friend Lookup');
// Code that causes a roundtrip, for example a query:
$s = oci_parse($c, 'select * from dual');
oci_execute($s);
oci_fetch_all($s, $res);
sleep(30);
?>
// While the script is running, the administrator can see the actions
// being performed:
sqlplus system/welcome
SQL> select action from v$session;
NOTES
Note
Oracle version requirement
This function is available when PHP is linked with Oracle Database libraries from version 10 g onwards.
Tip
Performance
With older versions of OCI8 or the Oracle Database, the client information can be set using the Oracle DBMS_APPLICATION_INFO pack-
age. This is less efficient than using oci_set_client_info(3).
Caution
Roundtrip Gotcha
Some but not all OCI8 functions cause roundtrips. Roundtrips to the database may not occur with queries when result caching is
enabled.
SEE ALSO
oci_set_module_name(3), oci_set_client_info(3), oci_set_client_identifier(3).
PHP Documentation Group OCI_SET_ACTION(3)