Executing Stored Proc from unix prompt.

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Sybase Stored Proc call from UNIX script.

Hi, I am new to shell scripting and Sybase database i need a help that i try to execute a SYBASE stored procedure from a Unix shell script and wanna write the output of the SP into a Text File.somehow i try to find a solution but whwn i try to run the script i am not getting the output file with...

2. Post Here to Contact Site Administrators and Moderators

Calling Sybase Stored proc from UNIX Shellscript.

Hi, I am new to shell scripting and Sybase database i need a help that i try to execute a SYBASE stored procedure from a Unix shell script and wanna write the output of the SP into a Text File, somehow i tried to find a solution but when i try to run the script i am not getting the output file with...

3. Shell Programming and Scripting

PL/SQL stored proc from ksh just inserts thumb and does nothing

Greeting everyone. Ok, I have spent the past few days googling for this and I keep hitting a wall. Many results brought me here, but the solutions were not quite right for this. Basically my script (ksh) is run with an arg for a csv. My script so far appears to be storing the values from my...

4. Shell Programming and Scripting

Stored Procedure not executing

below code is not executing the stored procedure,not sure what the issue.Even sqllog is blank.please help me its very urgent. sqlplus -s $connect_str@$DB_ORACLE_SID >> ${SQL_LOG_FILE} << EOF set serverout on set feed off set head off set pages 0 set colsep , set tab off set lin 150...

5. UNIX and Linux Applications

How to capture the value returned by a stored proc while executing it from SQSH connection

I have a very simple set up I am connecting to a MS SQL db using SQSH statement from a shell script In this sqsh connection i am trying to execute a stored proc However I want to capture the value returned by the stored proc. I haven't really come across anything useful so far which would...

6. Shell Programming and Scripting

Error when calling sybase stored proc from shell script

Hi, I am writing a script that needs to call a stored proc which would update a column in a table based on a condition. I need to also capture the number of rows updated. However, When I execute the script I keep getting this error: ./test_isql.sh: syntax error at line 33: `end of file'...

7. Shell Programming and Scripting

Executing Shell Script from Within a Sybase Stored Proc

Greetings, I need to make an open server call to a shell script from inside a Sybase Stored procedure. Coul any one please provide a sample code? TIA

8. UNIX for Dummies Questions & Answers

Executing Stored Proc from unic prompt.

Hi All, Want to know if is it possible to run / execute any stored procedures (sybase) from unix command prompt.? Thanks for your help in Advance. Regards, Arvind S.

9. Solaris

Executing MS-SQL stored procedures from Unix/C Program?

All, We are contemplating a port of an existing software product and would like to expend as little effort as possible. Our new database would be MS-SQL, and we would write stored procedures to perform common db operations. We'd like to call these stored procedures from C or C++ code running...

10. UNIX for Dummies Questions & Answers

Executing Oracle Stored Procs from Korn Shell

Can someone tell me how to execute an Oracle Stored Procedure from a Korn Shell Script. Previously, I'm able to execute standard sql using the following:- The_Output=`sqlplus................. << EOF select count(*) from abc / ...

LEARN ABOUT HPUX

pam_get_user

pam_get_user(3) 					     Library Functions Manual						   pam_get_user(3)

NAME

       pam_get_user - PAM routine to retrieve user name.

SYNOPSIS

       [ flag ... ] file ...  [ library ... ]

DESCRIPTION

       is  used  by  PAM service modules to retrieve the current user name from the PAM handle. If the user name has not been set, via or then the
       PAM conversation function will be used to prompt the user for the user name with the string "prompt".  If prompt is NULL,  then	is  called
       and the value of is used for prompting. If the value of is NULL, the following default prompt is used:

       After the user name is gathered by the conversation function, is called to set the value of

       By  convention, applications that need to prompt for a user name should call and set the value of before calling The service module's func-
       tion will then call to prompt for the user name. Note that certain PAM service modules (such as a smart card module) may override the value
       of and pass in their own prompt.

       Applications  that  call  multiple times should set the value of to NULL with before calling if they want the user to be prompted for a new
       user name each time.

       The value of user retrieved by should not be modified or freed.	The item will be released by

APPLICATION USAGE

       Refer to pam(3) for information on thread-safety of PAM interfaces.

RETURN VALUES

       Upon success, returns otherwise it returns an error code.  Refer to pam(3) for information on error related return values.

SEE ALSO

       pam(3), pam_start(3), pam_authenticate(3), pam_get_item(3), pam_set_item(3), pam_sm(3), pam_sm_authenticate(3), pam_end(3).

																   pam_get_user(3)

UNIX for Advanced & Expert Users