Help with C function and Oracle

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Calling Oracle function from script

Hi I need to call a function in database and update the return value of that function with a value in csv file. test.csv 1,2,3,,5,,,8,9,10 1,2,3,4,5,,,8,9,10 1,2,3,,,,,8,9,10In the above file I want to replace column 2 with a value extracted from database like (select student_id from...

2. Shell Programming and Scripting

set oracle variable in function

Hi, I have a function that is suposed to generate a AWR report: #-----------------------# gen_awr() #-----------------------# { sqlplus -s admin/admin@OCEAN11<<ENDOFSQL define num_days = '' define report_type = "html" define begin_snap =$snap1 define end_snap =%snap2 define...

3. Programming

Oracle Database: INSERT INTO with TO_DATE function

Hello, I am writting a procedure in shell script as, set serveroutput on declare date_gen DATE := $DATEGEN; begin INSERT INTO TBL1 ( EMPNAME,EMPID,EMPBDATE) VALUES($EMPNAME,$EMPID,TO_DATE(date_gen,'YYYY-MM-DD')); end; / Where DATEGEN is unix string variable which I need to use into...

4. Shell Programming and Scripting

unix capture oracle function error

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. Shell Programming and Scripting

getting return value from oracle function

So, in Oracle (11gR2) on aix I have a function like: CREATE OR REPLACE function COMMON.t2(var1 in varchar2, vari in number,var2 in out number) return number as begin insert into korisnik_temp(kor_inicia, kor_opisno) values(1, var1); var2:=0; return var2; exception when...

6. Shell Programming and Scripting

Oracle Function Needed

Dear Experts, Please find below the script in perl and can any body convert this script exactly in to oracle 9i fiunction which will return the required result same as perl. #!/usr/bin/perl $nof=@ARGV; @var2 = (); for($n=0; $n<$nof; $n++) { $filename = @ARGV; open...

7. Shell Programming and Scripting

Question for calling oracle function from perl

Dear Sir/Madam, I use the following way to call the oracle stored procedure in a perl script, but I do not know how to call a oracle function by the following way ? # ARGV is the oracle stored procedure name with parameters $str = "sqlplus -s <<-eof \n" . "$db_login...

8. Shell Programming and Scripting

ORACLE return a function to Solaris

Guys, I�m have this problem and I do not know what to do anymore: cod=`sqlplus -s ${DATABASE} << EOF set heading off feedback off verify off select max(eventid) from events; exit EOF` sed "s/CODEVENTID/${cod}/" c.ctl Abova What I�ve done. The CODEEVENTID is already set into a...

9. Shell Programming and Scripting

i want to call a oracle function in my shell script

LEARN ABOUT SUSE

apache::session::oracle

Session::Oracle(3)					User Contributed Perl Documentation					Session::Oracle(3)

NAME

       Apache::Session::Oracle - An implementation of Apache::Session

SYNOPSIS

	use Apache::Session::Oracle;

	#if you want Apache::Session to open new DB handles:

	tie %hash, 'Apache::Session::Oracle', $id, {
	   DataSource => 'dbi:Oracle:sessions',
	   UserName   => $db_user,
	   Password   => $db_pass,
	   Commit     => 1
	};

	#or, if your handles are already opened:

	tie %hash, 'Apache::Session::Oracle', $id, {
	   Handle => $dbh,
	   Commit => 1
	};

DESCRIPTION

       This module is an implementation of Apache::Session.  It uses the Oracle backing store and no locking.  See the example, and the
       documentation for Apache::Session::Store::Oracle for more details.

USAGE

       The special Apache::Session argument for this module is Commit.	You MUST provide the Commit argument, which instructs this module to
       either commit the transaction when it is finished, or to simply do nothing.  This feature is provided so that this module will not have
       adverse interactions with your local transaction policy, nor your local database handle caching policy.	The argument is mandatory in order
       to make you think about this problem.

       This module also respects the LongReadLen argument, which specifies the maximum size of the session object.  If not specified, the default
       maximum is 8 KB.

AUTHOR

       This module was written by Jeffrey William Baker <jwbaker@acm.org>.

SEE ALSO

       Apache::Session::File, Apache::Session::Flex, Apache::Session::DB_File, Apache::Session::Postgres, Apache::Session

perl v5.12.1							    2007-09-28							Session::Oracle(3)

Solaris