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 PHP

fbsql_read_clob

FBSQL_READ_CLOB(3)							 1							FBSQL_READ_CLOB(3)

fbsql_read_clob - Read a CLOB from the database

SYNOPSIS

       string fbsql_read_clob (string  $clob_handle, [resource	$link_identifier])

DESCRIPTION

	Reads CLOB data from the database.

	If  a select statement contains BLOB and/or CLOB columns FrontBase will return the data directly when data is fetched. This default behav-
       ior can be changed with fbsql_set_lob_mode(3) so the fetch functions will return handles to BLOB and CLOB data. If a handle  is	fetched  a
       user must call fbsql_read_clob(3) to get the actual CLOB data from the database.

PARAMETERS

	      o $clob_handle
		- A CLOB handle, returned by fbsql_create_clob(3).

	      o $
		link_identifier  -A FrontBase link identifier returned by fbsql_connect(3) or fbsql_pconnect(3).If optional and not specified, the
		function will try to find an open link to the FrontBase server and if no such link is found it	will  try  to  create  one  as	if
		fbsql_connect(3) was called with no arguments.

RETURN VALUES

	Returns a string containing the specified CLOB data.

EXAMPLES

       Example #1

	      fbsql_read_clob(3) example

	      <?php
	      $link = fbsql_pconnect("localhost", "_SYSTEM", "secret")
		  or die("Could not connect");
	      $sql = "SELECT CLOB_COLUMN FROM CLOB_TABLE;";
	      $rs = fbsql_query($sql, $link);
	      $row_data = fbsql_fetch_row($rs);
	      // $row_data[0] will now contain the clob data for the first row
	      fbsql_free_result($rs);

	      $rs = fbsql_query($sql, $link);
	      fbsql_set_lob_mode($rs, FBSQL_LOB_HANDLE);
	      $row_data = fbsql_fetch_row($rs);
	      // $row_data[0] will now contain a handle to the CLOB data in the first row
	      $clob_data = fbsql_read_clob($row_data[0]);
	      fbsql_free_result($rs);

	      ?>

SEE ALSO

       fbsql_create_clob(3), fbsql_read_blob(3), fbsql_set_lob_mode(3).

PHP Documentation Group 													FBSQL_READ_CLOB(3)

Shell Programming and Scripting