11-14-2001
Hi Amber,
You should be able to do somthing like...
#!/usr/bin/ksh
sqlplus -s scott/tiger@db << EOF > /tmp/result.$$
declare invar number;
declare outvar char(30);
exec myschema.mypkg.myproc(invar, outvar);
dbms_output.putline(outvar);
/
EOF
read result /tmp/result.$$
echo $result
rm -f /tmp/result.$$
exit 0
...if you do a search on the forum from "sqlplus" you should
see lots of good examples. The one above is just a quick and dirty
one.
8 More Discussions You Might Find Interesting
1. Linux
have following package installed
rpm -qa |grep ADMIN
It will give the following package installed:
ADMIN-4.0.0.1
Now I will upgrade the ADMIN package using the following command.
rpm --upgrade ADMIN-4.1.0.1
It will upgrade the ADMIN packagge to ADMIN-4.1.0.1
Now I want that... (0 Replies)
Discussion started by: amitpansuria
0 Replies
2. Shell Programming and Scripting
Hi all,
I need to pass a value from Unix to plsql block so that i can use the variable to in where caluse to get the desired output.
I tried useing $variable_name, but it doesn't work.
Any kind of help is appreciated.
Thanks in advance. (3 Replies)
Discussion started by: bankimmehta
3 Replies
3. AIX
Hello, I'm trying to build a (bff) package from an already installed program (clam antivirus) using mkinstallp. However, mkinstallp fails with "no such file: ./usr/lpp/<package name>/inst_root"
I'm not sure why all files get created ok except for these particular ones. Any help would be... (2 Replies)
Discussion started by: omonte
2 Replies
4. UNIX for Advanced & Expert Users
Friends,
Please let meknow, How we can find the dependancies of .dstream package & .rpm package before installation ?
For AIX, We can use the inutoc . command to create the .toc file for the bff package, What about Solaris & Linux ? (0 Replies)
Discussion started by: yb4779
0 Replies
5. Programming
HI,
When am creating one package body,its throwing error,
Code which am using to create is:
CREATE OR REPLACE PACKAGE BODY "MAMPROD"."PKG_QS_ADMIN" AS
-- ============================================================================
PROCEDURE CREATE_PARAMETERS
IS
BEGIN
... (2 Replies)
Discussion started by: Sanal
2 Replies
6. Linux
Dear all,
I would like to install a new version of package without remove old version on Centos and vice versa.
Please give me advice!
thanks much, (2 Replies)
Discussion started by: all4cfa
2 Replies
7. UNIX for Dummies Questions & Answers
Hello,
i have downloaded an rpm package "hadoop-0.20.205.0-1.amd64.rpm"
in /usr/local/ directory.
I'm trying to install the rpm package in a new path/location (/usr/local/hadoop-0.20.205), but i can't.
I did:
1st try: Didn't work
sudo rpm -i --prefix=/usr/local/hadoop-0.20.205... (1 Reply)
Discussion started by: g_p
1 Replies
8. Emergency UNIX and Linux Support
Hello,
i have installed a package by using the command
sudo rpm -i filepackage.rpm
package filepackage is already installed
when i try to remove it, i get an error saying "is not installed":
sudo rpm -e filepackage.rpm
error: package filepackage is not installed
How can... (4 Replies)
Discussion started by: g_p
4 Replies
LEARN ABOUT PHP
mysql_free_result
MYSQL_FREE_RESULT(3) 1 MYSQL_FREE_RESULT(3)
mysql_free_result - Free result memory
SYNOPSIS
Warning
This extension is deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the MySQLi or PDO_MySQL extension should
be used. See also MySQL: choosing an API guide and related FAQ for more information. Alternatives to this function include:
omysqli_free_result(3)
oAssign the value of
NULL to the PDO object, or PDOStatement::closeCursor
bool mysql_free_result (resource $result)
DESCRIPTION
mysql_free_result(3) will free all memory associated with the result identifier $result.
mysql_free_result(3) only needs to be called if you are concerned about how much memory is being used for queries that return large result
sets. All associated result memory is automatically freed at the end of the script's execution.
o $
result -The result resource that is being evaluated. This result comes from a call to mysql_query(3).
Returns TRUE on success or FALSE on failure.
If a non-resource is used for the $result, an error of level E_WARNING will be emitted. It's worth noting that mysql_query(3) only returns
a resource for SELECT, SHOW, EXPLAIN, and DESCRIBE queries.
Example #1
A mysql_free_result(3) example
<?php
$result = mysql_query("SELECT id,email FROM people WHERE id = '42'");
if (!$result) {
echo 'Could not run query: ' . mysql_error();
exit;
}
/* Use the result, assuming we're done with it afterwards */
$row = mysql_fetch_assoc($result);
/* Now we free up the result and continue on with our script */
mysql_free_result($result);
echo $row['id'];
echo $row['email'];
?>
Note
For backward compatibility, the following deprecated alias may be used: mysql_freeresult(3)
mysql_query(3), is_resource(3).
PHP Documentation Group MYSQL_FREE_RESULT(3)