Passing sql as parameter to unix function Post: 302605826

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Passing a string parameter to a function

I need to pass a parameter to a function in a script. My parameter is a string. When I display the parameter within my function, I only get the first word from string I pass in. How can I make the function receive the whole string (and not terminate at the first space it encounters)?. part of...

2. UNIX for Advanced & Expert Users

Parameter passing in a function

3. Shell Programming and Scripting

passing parameter from Shell-script to Sql-script

Dear Friends, Please help me to achieve the following: I want to pass one parameter from Shell-script to Sql-script. Example: My ShellScript.sh is calling report.sql like this: /bin/sqlplus /reports.sql And My report.sql is calling many Stored-Procedures like this: exec...

4. UNIX for Dummies Questions & Answers

Execute PL/SQL function from Unix script (.sql file)

Hi guys, I am new on here, I have a function in oracle that returns a specific value: create or replace PACKAGE BODY "CTC_ASDGET_SCHED" AS FUNCTION FN_ASDSCHEDULE_GET RETURN VARCHAR2 AS BEGIN DECLARE ASDSchedule varchar2(6); ASDComplete...

5. UNIX for Dummies Questions & Answers

Help Passing An Oracle parameter to a unix shell.

I have an Oracle concurrent program that I'm passing a parameter to a unix shell script. An example value of the Oracle parameter is PO_TOP. The Oracle parameter represents the unix env var PO_TOP, meaning, on the unix side there is env var called PO_TOP (ex value: /oradev/apps/po/11.0.3/). My...

6. Solaris

function parameter in unix

Hi, How to use a function with passing value as a parameter in unix ? With Regards

7. UNIX for Dummies Questions & Answers

Passing a Unix parameter to SQLPlus login command

hi All, i m trying to pass a user choice paramter from unix to sqlplus connect command here i want the user to enter the username and password he wants to connect in sql plus through read in unix and then automatically connect to that instance. sqlplus -s $1/$2 where $ 1 and $2 will b...

8. Shell Programming and Scripting

Passing a string variable from Unix to Sql Plus

Hi Guys, I am trying to pass a string variable from Unix shell script to sqlplus as a parameter. I have tried using single quotes with the variable name but it does not work. Please help me with it. I am using BASH. My code: Your help is much appreciated. Thanks, shil

9. Shell Programming and Scripting

Passing command as a function parameter

Hi All, Just trying to implement the below shell script using AIX ksh shell. myfunc { eval "$*" } CMD='ls -la /etc/hosts | awk '{print $9"|"$5}'' myfunc $CMD Keeping getting "|}: not found" errors, any pointers would greatly be appreciated. Kind Regards Ed Please...

10. Programming

Parameter passing to function with void * as Argument

Earlier I had one structure C typedef struct c { int cc; }CS; I used to call a library function say int GetData(CS *x) which was returning me the above structure C with data. GetData(CS *x) Function call used to be like: CS CSobj; GetData(&CSObj); Now there are two...

LEARN ABOUT REDHAT

perror

PERROR(1)						      General Commands Manual							 PERROR(1)

NAME

       perror  can  be	used  to display a description for a system error code, or an MyISAM/ISAM table handler error code. The error messages are
       mostly system dependent.

USAGE

       perror [OPTIONS] [ERRORCODE [ERRORCODE...]]

SYNOPSIS

       perror [-?|--help] [-I|--info] [-s|--silent] [-v|--verbose] [-V|--version]

DESCRIPTION

       -?|--help
	      Displays this help and exits.

       -I|--info
	      Synonym for the above.

       -s|--silent
	      Only print the error message

       -v|--verbose
	      Print error code and message (default).

       -V|--version
	      Displays version information and exits.

EXAMPLE

       shell> perror 64 79 Error code  64:  Machine is not on the network Error code  79:  Can not access a needed shared library

SEE ALSO

       isamchk (1), isamlog (1), mysqlaccess (1), mysqladmin (1), mysqlbug (1), mysqld (1), mysqldump (1), mysqlshow (1), msql2mysql  (1),  perror
       (1), replace (1), safe_mysqld (1), which1 (1), zap (1),

AUTHOR

       Ver  1.0,  distribution 3.23.29a Michael (Monty) Widenius (monty@tcx.se), TCX Datakonsult AB (http://www.tcx.se).  This software comes with
       no warranty.  Manual page by L. (Kill-9) Pedersen (kill-9@kill-9.dk), Mercurmedia Data Model Architect / system developer  (http://www.mer-
       curmedia.com)

								 19 December 2000							 PERROR(1)