Call a pl sql function from unix

10 More Discussions You Might Find Interesting

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

2. UNIX for Dummies Questions & Answers

Call SQL LOADER FROM UNIX

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

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

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

8. Shell Programming and Scripting

how can I call a pl/sql funciton in unix script

who can show me how to call pl/sql function or precudure in unix script.. cheers,

9. 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';...

10. Programming

sco unix 5.0.5 call sytem() function question!please help me!

i want to know the return value of calling system function in the sco unix 5.0.5.what is the meaning of the return value? ............ int ret; char cmd; strcpy(cmd,"compress -F -c file >file.Z"); ret = system(cmd); ............. i want to know how to judge whether the file's compress is...

LEARN ABOUT CENTOS

dblink_exec

DBLINK_EXEC(3)						  PostgreSQL 9.2.7 Documentation					    DBLINK_EXEC(3)

NAME

       dblink_exec - executes a command in a remote database

SYNOPSIS

       dblink_exec(text connname, text sql [, bool fail_on_error]) returns text
       dblink_exec(text connstr, text sql [, bool fail_on_error]) returns text
       dblink_exec(text sql [, bool fail_on_error]) returns text

DESCRIPTION

       dblink_exec executes a command (that is, any SQL statement that doesn't return rows) in a remote database.

       When two text arguments are given, the first one is first looked up as a persistent connection's name; if found, the command is executed on
       that connection. If not found, the first argument is treated as a connection info string as for dblink_connect, and the indicated
       connection is made just for the duration of this command.

ARGUMENTS

       conname
	   Name of the connection to use; omit this parameter to use the unnamed connection.

       connstr
	   A connection info string, as previously described for dblink_connect.

       sql
	   The SQL command that you wish to execute in the remote database, for example insert into foo values(0,'a','{"a0","b0","c0"}').

       fail_on_error
	   If true (the default when omitted) then an error thrown on the remote side of the connection causes an error to also be thrown locally.
	   If false, the remote error is locally reported as a NOTICE, and the function's return value is set to ERROR.

RETURN VALUE

       Returns status, either the command's status string or ERROR.

EXAMPLES

	   SELECT dblink_connect('dbname=dblink_test_standby');
	    dblink_connect
	   ----------------
	    OK
	   (1 row)

	   SELECT dblink_exec('insert into foo values(21,''z'',''{"a0","b0","c0"}'');');
	      dblink_exec
	   -----------------
	    INSERT 943366 1
	   (1 row)

	   SELECT dblink_connect('myconn', 'dbname=regression');
	    dblink_connect
	   ----------------
	    OK
	   (1 row)

	   SELECT dblink_exec('myconn', 'insert into foo values(21,''z'',''{"a0","b0","c0"}'');');
	      dblink_exec
	   ------------------
	    INSERT 6432584 1
	   (1 row)

	   SELECT dblink_exec('myconn', 'insert into pg_class values (''foo'')',false);
	   NOTICE:  sql error
	   DETAIL:  ERROR:  null value in column "relnamespace" violates not-null constraint

	    dblink_exec
	   -------------
	    ERROR
	   (1 row)

PostgreSQL 9.2.7						    2014-02-17							    DBLINK_EXEC(3)

Shell Programming and Scripting