Question for calling oracle function from perl


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Question for calling oracle function from perl
# 1  
Old 03-29-2008
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 ?

Code:
 # ARGV[0] is the oracle stored procedure name with parameters

  $str = "sqlplus -s <<-eof \n" .
            "$db_login \n" .
            "WHENEVER SQLERROR EXIT FAILURE; \n" .
            "EXEC @ARGV[0]; \n".
            "exit; \n".
            "EOF\n";

$return_code = system($str);

printf STDERR "$str\n";

Thanks
ili
Login or Register to Ask a Question

Previous Thread | Next Thread

10 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... (3 Replies)
Discussion started by: kev94
3 Replies

2. Shell Programming and Scripting

Help to Modify File Name in each function before calling another function.

I have a script which does gunzip, zip and untar. Input to the script is file name and file directory (where file is located) I am reading the input parameters as follows: FILENAME=$1 FILEDIR=$2 I have created 3 functions that are as follows: 1) gunzip file 2) unzip file... (2 Replies)
Discussion started by: pinnacle
2 Replies

3. Shell Programming and Scripting

Perl script for Calling a function and writing all its contents to a file

I have a function which does awk proceessing sub mergeDescription { system (q@awk -F'~' ' NR == FNR { A = $1 B = $2 C = $0 next } { n = split ( C, V, "~" ) if... (3 Replies)
Discussion started by: crypto87
3 Replies

4. UNIX for Dummies Questions & Answers

[Solved] Perl Question - split function with csv file

Hi all, I have a csv file that appears as follows: ,2013/03/26,2012/12/26,4,1,"2017/09/26,5.75%","2017/09/26,1,2018/09/26,1,2019/09/26,1,2020/09/26,1,2021/09/26,1",,,2012/12/26,now when i use the split function like this: my @f = split/,/; the split function will split the data that is... (2 Replies)
Discussion started by: WongSifu
2 Replies

5. Shell Programming and Scripting

PERL: Function calling using parameters

I have two variables. I need to call them using the same function my $dat1 ="abc"; my $dat2 ="def"; my $check; filecheck($dat1,$dat2); sub filecheck($) { $check = shift; print "first name is $check\n"; } print "this is fine\n"; sub filecheck($) { $check = shift; print "second... (2 Replies)
Discussion started by: irudayaraj
2 Replies

6. Homework & Coursework Questions

Shell script calling Perl function, sort and find data, write to new files

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: I must write a shell script that calls two external Perl functions--one of which sorts the data in a file, and... (6 Replies)
Discussion started by: kowit010
6 Replies

7. Shell Programming and Scripting

PERL and Oracle 11.2 question

Hi, we have PERL 64-bit build with Oracle 10g DBD . PERL database connection are working fine. Database upgraded to 11.2 and in PERL documents it says still use 10g DBD to connect to 11.2. when I try some test connections, I am getting this error . Did anyone see this error before . I set the... (2 Replies)
Discussion started by: talashil
2 Replies

8. Shell Programming and Scripting

SHELL SCRIPT Function Calling Another Function Please Help...

This is my function which is creating three variables based on counter & writing these variable to database by calling another function writeRecord but only one record is getting wrote in DB.... Please advise ASAP...:confused: function InsertFtg { FTGSTR="" echo "Saurabh is GREAT $#" let... (2 Replies)
Discussion started by: omkar.sonawane
2 Replies

9. Shell Programming and Scripting

Return a value from called function to the calling function

I have two scripts. script1.sh looks -------------------------------- #!/bin/bash display() { echo "Welcome to Unix" } display ----------------------------- Script2.sh #!/bin/bash sh script1.sh //simply calling script1.sh ------------------------------ (1 Reply)
Discussion started by: mvictorvijayan
1 Replies

10. Shell Programming and Scripting

Calling a C-function froma Perl script

Hi All, How can we call a c function from a perl script? Is it the same way as we do for shell script ? Thanks in advance JS (9 Replies)
Discussion started by: jisha
9 Replies
Login or Register to Ask a Question
MAKE-SQLDEVELOPER-PACKAGE(1)			    Oracle SQL Developer Debian package builder 		      MAKE-SQLDEVELOPER-PACKAGE(1)

NAME
make-sqldeveloper-package - Oracle SQL Developer Debian package builder SYNOPSIS
make-sqldeveloper-package [options] <file> DESCRIPTION
make-sqldeveloper-package is a utility that builds a Debian package for Oracle SQL Developer. The Oracle SQL Developer program is governed by the copyright holder (Oracle USA, Inc.), so you may be limited as to what you can do with the resulting package (i.e. no redistribution, etc). This utility will simply help you create the Debian package, it is your responsibility to use the resulting package acordingly with the OTN license, a copy of which is included in the created package, that you must agree on when downloading the source. This utility will require you to download the "Oracle SQL Developer for other platforms" archive from <http://www.oracle.com/technet- work/developer-tools/sql-developer/> to create the Debian package from. OPTIONS
-b|--build-dir <dir> base directory to build package (autogenerated) -e|--email <email> local maintainer email (use DEBEMAIL or auto-generate) -i|--install install the generated package - needs root privilege (no) -k|--keep-dir keep the build directory (no) -l|--revision <number> local revision to append to package version (1) -m|--maintainer <name> local maintainer name (use DEBFULLNAME or leave empty) -r|--root-command <command> command to gain root privilege for package build (fakeroot) -u|--upstream-version <version> force the upstream version (autodetected) -h|--help display the help screen -v|--version show the program version <file> the "Oracle SQL Developer for other platforms" archive from <http://www.oracle.com/technetwork/developer-tools/sql-developer/> AUTHOR
make-sqldeveloper-package was written by Lazarus Long <lazarus.long@bigfoot.com>. This manual page was written by Lazarus Long <lazarus.long@bigfoot.com>, for the Debian project (but may be used by others). GNU
2012-11-13 MAKE-SQLDEVELOPER-PACKAGE(1)