Sponsored Content
Top Forums Shell Programming and Scripting how can I call a pl/sql funciton in unix script Post 89484 by YoYo on Sunday 13th of November 2005 08:51:06 PM
Old 11-13-2005
i wanna

funciton A (p1 number)
{
return v2,
}

MM()
{
somehow call the function A and use the return value;

}
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to call pl/sql in unix script

sample code as following: test_sql(){ #test#echo test_sql str=`$ORACLE_BIN/sqlplus -s $user/$passwd <<EOM set verify off set heading off set feedback off #--------start pl/sql { DECLARE CURSOR pah_cs IS select id from table where letter = 'abcd';... (6 Replies)
Discussion started by: YoYo
6 Replies

2. UNIX for Advanced & Expert Users

How to call SQL procedure from UNIX Shellscript ?

Hi All I would be thankful to you all if you will guide me the steps to call a stored proc. from unix shell script. that stored proc. could be parameterised or parameterless developed in SQL. Any info. in this topic would help me..... Thanks in advance.... (1 Reply)
Discussion started by: varungupta
1 Replies

3. Shell Programming and Scripting

Unix call to Oracle PL/SQL pkg/store.proc

HI, I'm trying to get this right, please can you help. In my unix korn shell script, I call an oracle stored proc within a package and I specify 3 parameters, 2 of which are IN OUT parameters (i.e. I expect the stored proc to change them and return them back to me). Does the unix code... (7 Replies)
Discussion started by: csong2
7 Replies

4. Shell Programming and Scripting

Can SQL Server call be made from unix sh

Hi, I need to make SQL Server procedure call (exec <proc name>)from unix shell script. First of all I would like to know if it is possible. I know we can do it from Oracle but not sure about SQL Server. Version: SunOS 5.8 SQL 8.0 I have made the below entry in the interface file. NSXNA267 ... (0 Replies)
Discussion started by: sspreethi
0 Replies

5. Shell Programming and Scripting

Call a pl sql function from unix

hi, I want to know how to call a pl sql function testfunction(param1,..) that returns a value and grab that value in a shell variable. Thnx in advance ---------- Post updated 03-30-10 at 11:58 AM ---------- Previous update was 03-29-10 at 03:49 PM ---------- thnx a lot jim (0 Replies)
Discussion started by: austinhell3_16
0 Replies

6. UNIX for Dummies Questions & Answers

Call sql script

I want to call the sql query from UNIX..but how to set page size and other necessary parameters i don't know plz guide me how to do this (2 Replies)
Discussion started by: sagar_1986
2 Replies

7. UNIX for Advanced & Expert Users

Using PHP , call a sql inside a unix script

I am running the xampp on WINDOWS, and my php script is connecting to a unix script on a different server (ssh2_connect("11.31.138.56", 22). I am running the unix script and inside this script I am calling the .sql file . The SQL is connecting to oracle db on the unix server. But the sqlplus... (2 Replies)
Discussion started by: madfox
2 Replies

8. Shell Programming and Scripting

Call sql script from UNIX shell script

I know this question is out there in many forums, but I tried all the combinations in vain. I'm basically trying to call a sql script from a shell script. Below is my sql script (plsql.sql) DELCARE v_empno NUMBER := '&empno'; BEGIN select ename,sal from emp where empno = v_empno;... (3 Replies)
Discussion started by: FName_LName
3 Replies

9. UNIX for Dummies Questions & Answers

Call SQL LOADER FROM UNIX

HI Experts, I am pretty new to scripting and i need to create a perl or shell script which should fetch a file from local directory and insert the data into a table using sql loader. This will be later added to chron job to run daily and fetch all files and load them into the table. Also i... (1 Reply)
Discussion started by: sam1234
1 Replies

10. UNIX for Dummies Questions & Answers

Call SQL LOADER FROM UNIX

HI Experts, I am pretty new to scripting and i need to create a perl or shell script which should fetch a file from local directory and insert the data into a table using sql loader. This will be later added to chron job to run daily and fetch all files and load them into the table. Also i... (1 Reply)
Discussion started by: sam1234
1 Replies
Data::Validate::Domain(3pm)				User Contributed Perl Documentation			       Data::Validate::Domain(3pm)

NAME
Data::Validate::Domain - domain validation methods SYNOPSIS
use Data::Validate::Domain qw(is_domain); # as a function my $test = is_domain($suspect); die "$test is not a domain" unless defined $test; or my $test = is_domain($suspect,\%options); die "$test is not a domain" unless defined $test; # or as an object my $v = Data::Validate::Domain->new(%options); my $test = $v->is_domain($suspect); die "$test is not a domain" unless defined $test; DESCRIPTION
This module collects domain validation routines to make input validation, and untainting easier and more readable. All functions return an untainted value if the test passes, and undef if it fails. This means that you should always check for a defined status explicitly. Don't assume the return will be true. (e.g. is_username('0')) The value to test is always the first (and often only) argument. FUNCTIONS
new - constructor for OO usage $obj = Data::Validate::Domain->new(); my %options = ( domain_allow_underscore => 1, ); or my %options = ( domain_allow_single_label => 1, domain_private_tld => { 'privatetld1 ' => 1, 'privatetld2' => 1, } ); or my %options = ( domain_allow_single_label => 1, domain_private_tld => qr /^(?:privatetld1|privatetld2)$/, ); $obj = Data::Validate::Domain->new(%options); Description Returns a Data::Validator::Domain object. This lets you access all the validator function calls as methods without importing them into your namespace or using the clumsy Data::Validate::Domain::function_name() format. Options domain_allow_underscore According to RFC underscores are forbidden in "hostnames" but not "domainnames". By default is_domain,is_domain_label, and is_hostname will fail if you include underscores, setting this to a true value with authorize the use of underscores in all functions. domain_allow_single_label By default is_domain will fail if you ask it to verify a domain that only has a single label i.e. 'neely.cx' is good, but 'com' would fail. If you set this option to a true value then is_domain will allow single label domains through. This is most likely to be useful in combination with domain_private_tld domain_private_tld By default is_domain requires all domains to have a valid TLD (i.e. com, net, org, uk, etc), this is verified using the Net::Domain::TLD module. This behavior can be extended in two different ways. Either a hash reference can be supplied keyed by the additional TLD's, or you can supply a precompiled regular expression. NOTE: The TLD is normalized to the lower case form prior to the check being done. This is done only for the TLD check, and does not alter the output in any way. The hash reference example: domain_private_tld => { 'privatetld1 ' => 1, 'privatetld2' => 1, } The precompiled regualar expression example: domain_private_tld => qr /^(?:privatetld1|privatetld2)$/, Returns Returns a Data::Validate::Domain object is_domain - does the value look like a domain name? is_domain($value); or $obj->is_domain($value); or is_domain($value,\%options); or $obj->is_domain($value,\%options); Description Returns the untainted domain name if the test value appears to be a well-formed domain name. Note: See new for list of options and how those alter the behavior of this funciton. Arguments $value The potential domain to test. Returns Returns the untainted domain on success, undef on failure. Notes, Exceptions, & Bugs The function does not make any attempt to check whether a domain actually exists. It only looks to see that the format is appropriate. A dotted quad (such as 127.0.0.1) is not considered a domain and will return false. See Data::Validate::IP(3) for IP Validation. Performs a lookup via Net::Domain::TLD to verify that the TLD is valid for this domain. Does not consider "domain.com." a valid format. From RFC 952 A "name" (Net, Host, Gateway, or Domain name) is a text string up to 24 characters drawn from the alphabet (A-Z), digits (0-9), minus sign (-), and period (.). Note that periods are only allowed when they serve to delimit components of "domain style names". No blank or space characters are permitted as part of a name. No distinction is made between upper and lower case. The first character must be an alpha character [Relaxed in RFC 1123] . The last character must not be a minus sign or period. From RFC 1035 labels 63 octets or less names 255 octets or less [snip] limit the label to 63 octets or less. To simplify implementations, the total length of a domain name (i.e., label octets and label length octets) is restricted to 255 octets or less. From RFC 1123 One aspect of host name syntax is hereby changed: the restriction on the first character is relaxed to allow either a letter or a digit. Host software MUST support this more liberal syntax. Host software MUST handle host names of up to 63 characters and SHOULD handle host names of up to 255 characters. is_hostname - does the value look like a hostname is_hostname($value); or $obj->is_hostname($value); or is_hostname($value,\%options); or $obj->is_hostname($value,\%options); Description Returns the untainted hostname if the test value appears to be a well-formed hostname. Note: See new for list of options and how those alter the behavior of this funciton. Arguments $value The potential hostname to test. Returns Returns the untainted hostname on success, undef on failure. Notes, Exceptions, & Bugs The function does not make any attempt to check whether a hostname actually exists. It only looks to see that the format is appropriate. Functions much like is_domain, except that it does not verify whether or not a valid TLD has been supplied and allows for there to only be a single component of the hostname (i.e www) Hostnames might or might not have a valid TLD attached. is_domain_label - does the value look like a domain label? is_domain_label($value); or $obj->is_domain_label($value); or is_domain_label($value,\%options); or $obj->is_domain_label($value,\%options); Description Returns the untainted domain label if the test value appears to be a well-formed domain label. Note: See new for list of options and how those alter the behavior of this funciton. Arguments $value The potential ip to test. Returns Returns the untainted domain label on success, undef on failure. Notes, Exceptions, & Bugs The function does not make any attempt to check whether a domain label actually exists. It only looks to see that the format is appropriate. SEE ALSO
[RFC 1034] [RFC 1035] [RFC 2181] [RFC 1123] Data::Validate(3) Data::Validate::IP(3) AUTHOR
Neil Neely <neil@neely.cx>. ACKNOWLEDGEMENTS
Thanks to Richard Sonnen <sonnen@richardsonnen.com> for writing the Data::Validate module. Thanks to Len Reed <lreed@levanta.com> for helping develop the options mechanism for Data::Validate modules. COPYRIGHT AND LICENSE
Copyright (c) 2005-2007 Neil Neely. This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself, either Perl version 5.8.2 or, at your option, any later version of Perl 5 you may have available. perl v5.14.2 2010-12-29 Data::Validate::Domain(3pm)
All times are GMT -4. The time now is 06:20 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy