i have an oracle function which returns two values, one is the error message if the function encounters anything and another one which returns a number
Do you mean an Oracle procedure ?
An Oracle function can return only a single value to the caller. The return value is strongly typed via the RETURN keyword, which means you can only return a number.
The error message you are talking about is thrown in case of an exception. It is not a return value.
Quote:
i need to capture both
and pass it on to unix shell script
...
If you leave out the exception section from the function, then maybe something like this -
should assign the returned number or the error message to x.
Here <login_credentials> are your Oracle login credentials in the form username/password@SID and <your_function> is the invocation of your function that returns a number.
HTH,
tyler_durden
Last edited by durden_tyler; 04-05-2010 at 10:58 AM..
I have two string returning function in ESQL/C
char *segment_name(lbuffer)
char *lbuffer;
{.....
and
char *get_bpdvalue(f_name)
char *f_name;
{......
both declared above main()
char *get_bpdvalue();
char *segment_name();
my problem is segment_name works on sprintf and strcpy... (5 Replies)
Hello Experts
how do I get a output value from Oracle to Unix . Please give me sample Unix codings
Scenario (Filne name : test.sh <argument > )
---------
1. Passing argument from unix to sql
2. connecting to Oracle & from oracle get output
3. Pass the output to ... (3 Replies)
Hi all,
I am very new to BASH shell programming. I need to return an integer from a function to the caller function. I did this:
but it keeps giving me wrong return:
Can someone help me out here, please?
Thanks (2 Replies)
hi
how can I return multiple values from a C function. I tried the following:
#include <stdio.h>
void foo(int id, char *first_name, char *last_name)
{
/*
this is just an example to illustrate my problem... real code makes
use of the "id" parameter.
*/
first_name = (char... (8 Replies)
Hi All
In my script, I can call on several functions. I have a logging function that is called by any of these functions. What I would like is some way of identifying which function I am using and pass this to the log function as some parameter.
Is there some built in command or way of... (3 Replies)
Hi
i am calling a stored procedure from unix shell like this call
test_proc('0002','20100218');
the stored procedure was giving output
like this dbms_output.put_line(' processed earlier');
i want to see the output in the unix shell where i called.
Thanks
barani (6 Replies)
Hi,
I want to execute an oracle function from unix script so for that I created a sample oracle function as below:
create or replace
function test_fn(test_date out varchar2)
RETURN varchar2
IS
BEGIN
select to_char(sysdate,'DD-MON-YY') into test_date from dual;
return test_date;... (5 Replies)
Hi
I am pretty confused in returning and capturing multiple values
i have defined a function which should return values "total, difference"
i have used as
#!/usr/bin/ksh
calc()
{
total=$1+$2
echo "$total"
diff=$2-$1
echo "$diff"
}
I have invoked this function as
calc 5 8
Now i... (2 Replies)
Discussion started by: Priya Amaresh
2 Replies
LEARN ABOUT SUSE
apache::session::store::oracle
Session::Store::Oracle(3) User Contributed Perl Documentation Session::Store::Oracle(3)NAME
Apache::Session::Store::Oracle - Store persistent data in a Oracle database
SYNOPSIS
use Apache::Session::Store::Oracle;
my $store = new Apache::Session::Store::Oracle;
$store->insert($ref);
$store->update($ref);
$store->materialize($ref);
$store->remove($ref);
DESCRIPTION
Apache::Session::Store::Oracle fulfills the storage interface of Apache::Session. Session data is stored in a Oracle database.
SCHEMA
To use this module, you will need at least these columns in a table called 'sessions':
id varchar2(32) # or however long your session IDs are.
a_session long
To create this schema, you can execute this command using the sqlplus program:
CREATE TABLE sessions (
id varchar2(32) not null primary key,
a_session long
);
If you use some other command, ensure that there is a unique index on the table's id column.
CONFIGURATION
The module must know what datasource, username, and password to use when connecting to the database. These values can be set using the
options hash (see Apache::Session documentation). The options are DataSource, UserName, and Password.
Example:
tie %hash, 'Apache::Session::Oracle', $id, {
DataSource => 'dbi:Oracle:database',
UserName => 'database_user',
Password => 'K00l'
};
Instead, you may pass in an already-opened DBI handle to your database.
tie %hash, 'Apache::Session::Oracle', $id, {
Handle => $dbh
};
The last option is LongReadLen, which specifies the maximum size of the session object. If not supplied, the default maximum size is 8 KB.
AUTHOR
This modules was written by Jeffrey William Baker <jwbaker@acm.org>
A fix for the commit policy was contributed by Michael Schout <mschout@gkg.net>
SEE ALSO
Apache::Session, Apache::Session::Store::DBI
perl v5.12.1 2007-09-28 Session::Store::Oracle(3)