Sponsored Content
Full Discussion: Pls help for the doubt
Top Forums Shell Programming and Scripting Pls help for the doubt Post 302114015 by rahulrathod on Thursday 12th of April 2007 03:26:07 AM
Old 04-12-2007
For the 1st question https://www.unix.com/showthread.php?t=7077

and for the 2nd try the following snippet.

Code:
sqlplus -silent ${DBUSER}/${DBPASS}@${ORACLE_SID} << ENDSQL
      set feedback off serveroutput on size 5000
      execute pkg_1.pr_1;
      commit;
      Delete from table1;
      commit;
ENDSQL

 

10 More Discussions You Might Find Interesting

1. Linux

pls help me

we hv a big enviroment networked. we use squid proxy. access allowed by src address previously. we have win2000 network with ads. my requirement is the proxy should allow domain users only for access. how can i map my windows userdatabase with squid is there any thing specific which has 2 b... (1 Reply)
Discussion started by: sriram.s
1 Replies

2. UNIX for Dummies Questions & Answers

Need help pls

Hi, I'm a newbie. I need help on my first assignment in UNIX. 1. How do I determine the number of non-empty directories? I was told to create a variable ARCHIVE, which points to the directory that contains the archive of the messages. But I'm so dumb and I don't even know how to do this. 2. In... (1 Reply)
Discussion started by: hygsg
1 Replies

3. UNIX for Dummies Questions & Answers

Pls Help

Hi every one I have got very very bad Email, My question is: How can I get all information about that f*** Email, I do mean IP,reall name, Adress, user name, password etc... I wonder if there is any program or website that I can see that email, help me please When I used windows Xp(old... (2 Replies)
Discussion started by: Cano
2 Replies

4. UNIX for Dummies Questions & Answers

Help pls!

Hi... Why should I press F1 to start windows?! I have Xp in my computer... thx 4 help Cano (1 Reply)
Discussion started by: Cano
1 Replies

5. Shell Programming and Scripting

pls help

I have a list of variables: ss1, ss5, ss6, ss8, st2 etc. (these values are not fixed, configurable). Now, I have assigned ss5=”test”. And I want to search in the list for the string “test” to know which variable is having the value “test”. Can u pls tell me how to do this? (10 Replies)
Discussion started by: kanchan_cp
10 Replies

6. Shell Programming and Scripting

Pls Help

Hi Folks, I am new to this forum. and I just started learning shell scripting. I have a file called energy.out which looks like: -218213.3729 -224215.0059 -221509.3651 -221094.2627 -220660.3223 -222630.2339 -218697.8693 Now I want to calculate the average of energies and then average... (3 Replies)
Discussion started by: pkar
3 Replies

7. Shell Programming and Scripting

Pls Pls do help me

When i run this command, everything is ok. The file can be email and attached but soon after i download the file, the file cant be read. It's seem corrupted. Totally cant be read although i'm using context or wordfile. Original file generated at ek_bkup/alert/tbspace_datafile.log is OK..... ... (7 Replies)
Discussion started by: adzuanamir
7 Replies

8. UNIX for Dummies Questions & Answers

HELP PLs

I have this code: #!/bin/sh awk 'BEGIN NR == 2 repl = "PHI" $4 = repl print $0 'dryloop.txt and this code: #!/bin/sh sed -e '1s/\|$/\|COMID\|/g' -e 's/^087.*$/&PHI\|g' hl.dsldryloop > textdry.txt My code won't work. I want to change the COMID of lines starting with 087 . this is my... (15 Replies)
Discussion started by: arkhei
15 Replies

9. Solaris

Doubt in zone configuration pls help

Hi I am new to solaris I am running solaris from sun virtual box I am trying to create a zone but it is giving some error... First i configured my zone zonename: test zonepath: /rpool/zones/test brand: ipkg autoboot: true bootargs: pool: limitpriv: scheduling-class: ip-type:... (1 Reply)
Discussion started by: vijaysachin
1 Replies

10. Homework & Coursework Questions

Help pls

How to find the ten most common words in a file (1 Reply)
Discussion started by: jass
1 Replies
SWF_CLOSEFILE(3)							 1							  SWF_CLOSEFILE(3)

swf_closefile - Close the current Shockwave Flash file

SYNOPSIS
void swf_closefile ([int $return_file]) DESCRIPTION
Close a file that was opened by the swf_openfile(3) function. PARAMETERS
o $return_file - If set then the contents of the SWF file are returned from the function. RETURN VALUES
No value is returned. EXAMPLES
Example #1 Creating a simple flash file based on user input and outputting it and saving it in a database <?php // The $text variable is submitted by the // user // Global variables for database // access (used in the swf_savedata() function) $DBHOST = "localhost"; $DBUSER = "sterling"; $DBPASS = "secret"; swf_openfile("php://stdout", 256, 256, 30, 1, 1, 1); swf_definefont(10, "Ligon-Bold"); swf_fontsize(12); swf_fontslant(10); swf_definetext(11, $text, 1); swf_pushmatrix(); swf_translate(-50, 80, 0); swf_placeobject(11, 60); swf_popmatrix(); swf_showframe(); swf_startdoaction(); swf_actionstop(); swf_enddoaction(); $data = swf_closefile(1); $data ? swf_savedata($data) : die("Error could not save SWF file"); // void swf_savedata(string data) // Save the generated file a database // for later retrieval function swf_savedata($data) { global $DBHOST, $DBUSER, $DBPASS; $dbh = @mysql_connect($DBHOST, $DBUSER, $DBPASS); if (!$dbh) { die (sprintf("Error [%d]: %s", mysql_errno(), mysql_error())); } $stmt = "INSERT INTO swf_files (file) VALUES ('$data')"; $sth = @mysql_query($stmt, $dbh); if (!$sth) { die (sprintf("Error [%d]: %s", mysql_errno(), mysql_error())); } @mysql_free_result($sth); @mysql_close($dbh); } ?> SEE ALSO
swf_openfile(3). PHP Documentation Group SWF_CLOSEFILE(3)
All times are GMT -4. The time now is 12:43 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy