Help with pl/sql stored procedure Post: 302368012

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Oracle stored procedure.

I am using sqlplus. I have the stored procedure name. How can i print the stored procedure content?

2. Shell Programming and Scripting

Stored Procedure on NT/SQLServer

Hi: How will I execute a Stored Procedure that sits on NT/SQLServer. Any help would be appreciated. Thanks

3. Shell Programming and Scripting

Calling MYSQL Stored Procedure?

Hi, Can anyone help me with the correct syntax to call a MYSQL stored procedure from a shell script. I have tried the following, (no input params): /usr/bin/mysql -uadmin -ppassword call TL_CLENSEDATA(); resulting in error: /home/hosting/data/scripts/dbclense.sh: line 12: syntax error...

4. Shell Programming and Scripting

calling a PL/SQL stored procedure from KSH

Hi I have a stored procedure which should be called from KSH. Could ayone please help me with this. Thanks

5. Shell Programming and Scripting

How to compile a stored procedure that is there with in a script file(.sql) in unix

Hi, How can i compile the procedure code that is there in a script file (.sql) in unix.

6. Shell Programming and Scripting

need to call 3 stored procedure at the same time

Hi GUYS, I need to trigger 3 stored procedure at the same time.. I know how to trigger the stored procedure. If anybody can tell me how to trigger 3 different process at the same time parallelly.. that would be helpful.. Thanks for your help in advance, Magesh

7. UNIX for Dummies Questions & Answers

Calling stored procedure from unix

Hi, My stored procedure returns a value. How to retrieve the value and display in unix. Stored procedure CREATE OR REPLACE PROCEDURE gohan(num INT) IS BEGIN DBMS_OUTPUT.PUT_LINE('My lucky number is ' || num); END; Unix Scripting i used sqlplus -s...

8. 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...

9. Shell Programming and Scripting

How to call a stored procedure inside a loop?

How to call a stored procedure inside a loop export PATH=$ORACLE_HOME/bin:$PATH ORACLE_SID=xxxx; export ORACLE_SID ORAENV_ASK=NO TODAY_DATE=$(date +"%Y%m%d") LOGFILE=/var/opt/gogd/cust/scripts/${TODAY_DATE}_sap_cust_rel.log echo 'Connected' PARCUST=sap_cust_rel.par sqlldr...

10. Shell Programming and Scripting

How to KIll a Stored procedure invoked by UNIX?

Hi, I am using sql server 2008 version and invoking the stored procedure using unix script. I want to know the procedure of killing the stored procedure in sql server. If I kill -9 the unix script will it also terminate the process at the SQL server. When I executed the kill -9 PID in unix...

LEARN ABOUT CENTOS

xtappsetwarninghandler

XtAppError(3)							   XT FUNCTIONS 						     XtAppError(3)

NAME

       XtAppError, XtAppSetErrorHandler, XtAppSetWarningHandler, XtAppWarning - low-level error handlers

SYNTAX

       void XtAppError(XtAppContext app_context, String message);

       void XtAppSetErrorHandler(XtAppContext app_context, XtErrorHandler handler);

       void XtAppSetWarningHandler(XtAppContext app_context, XtErrorHandler handler);

       void XtAppWarning(XtAppContext app_context, String message);

ARGUMENTS

       app_context
		 Specifies the application context.

       message	 Specifies the nonfatal error message that is to be reported.

       handler	 Specifies the new fatal error procedure, which should not return, or the nonfatal error procedure, which usually returns.

       message	 Specifies the message that is to be reported.

DESCRIPTION

       The XtAppError function calls the installed error procedure and passes the specified message.

       The XtAppSetErrorHandler function registers the specified procedure, which is called when a fatal error condition occurs.

       The XtAppSetWarningHandler registers the specified procedure, which is called when a nonfatal error condition occurs.

       The XtAppWarning function calls the installed nonfatal error procedure and passes the specified message.

SEE ALSO

       XtAppGetErrorDatabase(3), XtAppErrorMsg(3)
       X Toolkit Intrinsics - C Language Interface
       Xlib - C Language X Interface

X Version 11							    libXt 1.1.4 						     XtAppError(3)

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Oracle stored procedure.

Discussion started by: kamil

2. Shell Programming and Scripting

Stored Procedure on NT/SQLServer

Discussion started by: mayohan

3. Shell Programming and Scripting

Calling MYSQL Stored Procedure?

Discussion started by: kshelluser

4. Shell Programming and Scripting

calling a PL/SQL stored procedure from KSH

Discussion started by: BlAhEr