How to call stored procedure with CLOB out parameter from shell script?

10 More Discussions You Might Find Interesting

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

2. Shell Programming and Scripting

How to get OUT parameter of a stored procedure in shell script?

I am invoking a SQL script from shell script. This SQL script will invoke a stored procedure(which has the OUT parameter). I want to have the OUT parameter in the shell script as a variable. Is this possible?

3. Shell Programming and Scripting

How to write CLOB parameter in a file or XML using shell script?

I executed a oracle stored procedure using shell script. How can i get the OUT parameter of the procedure(CLOB) and write it in a file or XML in UNIX environment using shell script?

4. Shell Programming and Scripting

How to call a stored procedure from shell program?

How to call a stored procedure from shell program

5. Shell Programming and Scripting

Call and redirect output of Oracle stored procedure from unix script

Hi, Can you assist me in how to redirect the output of oracle stored procedure from unix script? Something similar to what i did for sybase isql -U$MYDBLOG -D$MYDBNAME -S$MYDBSVR -P$MYDBPWD -o$MYFILE<< %% proc_my_test 8 go %% Thanks in advance - jak

6. Shell Programming and Scripting

how to call oracle stored procedure from unix shell

Hi i want to call a oracle stored procedure from unix (using bash shell). consider this is my oracle stored procedure with parameter create procedure testproc(name IN varchar, age IN Number, id OUT Number ) AS begin id=1; dbms_output.put.line('successfull validation') end;...

7. Programming

How to call sqlloader from stored procedure!!! Advise

Hi , I have a dellimited .dat file and a sqlloader. I want to call the sqlloader from a oracle stored procedure. The procedure should return the result of sqlloader's execution.

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

9. Shell Programming and Scripting

Need to call stored procedure from unix script

Hi Guys, I have a stored procedure which has 5 out parameters. I need to call the stored procedure from the script. When i use the following in my script, db2 "CALL FCFM.PART_MASTER_TMP($Return_code,$Message,$Message1,$SQL,$Load_count)" >> $LOG_FILE I am getting an error.. Please...

10. Shell Programming and Scripting

passing parameter 4m shell script to a DB stored procedure

hi all please tell me how to pass parameters 4m shell script to a DataBase stored procedure. To be specific i have sybase DB. i mean i want the syntax of the command.. how to connect to DB, pass user id and password, pass the required parameter to SP.. .. need ur help frnds.. hema

LEARN ABOUT PHP

fbsql_set_lob_mode

FBSQL_SET_LOB_MODE(3)							 1						     FBSQL_SET_LOB_MODE(3)

fbsql_set_lob_mode - Set the LOB retrieve mode for a FrontBase result set

SYNOPSIS

       bool fbsql_set_lob_mode (resource  $result, int	$lob_mode)

DESCRIPTION

	Sets the mode for retrieving LOB data from the database.

	When BLOB and CLOB data is retrieved in FrontBase it can be retrieved direct or indirect. Direct retrieved LOB data will always be fetched
       no matter the setting of the lob mode. If the LOB data is less than 512 bytes it will always be retrieved directly.

PARAMETERS

	      o $
		result -A result identifier returned by fbsql_query(3) or fbsql_db_query(3).

	      o $lob_mode
		- Can be one of:

		     o FBSQL_LOB_DIRECT - LOB data is retrieved directly. When data is fetched from  the  database  with  fbsql_fetch_row(3),  and
		       other  fetch  functions, all CLOB and BLOB columns will be returned as ordinary columns. This is the default value on a new
		       FrontBase result.

		     o FBSQL_LOB_HANDLE - LOB data  is	retrieved  as  handles	to  the  data.	When  data  is	fetched  from  the  database  with
		       fbsql_fetch_row(3),  and  other	fetch  functions,  LOB data will be returned as a handle to the data if the data is stored
		       indirect or the data if it is stored direct.  If  a  handle  is	returned  it  will  be	a  27  byte  string  formatted	as
		       @'000000000000000000000000'.

RETURN VALUES

	Returns TRUE on success or FALSE on failure.

SEE ALSO

       fbsql_create_blob(3), fbsql_create_clob(3), fbsql_read_blob(3), fbsql_read_clob(3).

PHP Documentation Group 												     FBSQL_SET_LOB_MODE(3)

Shell Programming and Scripting