10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hi Guys,
is there a way to pass parameter into oracle store procedure by reading date range in file and increment accordingly. Something like this
file.txt
01-JAN-2015
03-JAN-2015
sqlplus -s user/pwd@DB
execute TEST( to_date( '01-JAN-2015, 'dd.mm.yyyy' ), to_date( '03-JAN-2015', ... (1 Reply)
Discussion started by: rohit_shinez
1 Replies
2. Shell Programming and Scripting
Friends,
I pass some runtime arguments (date, number) through ksh script to Oracle procedure, use input value and pass it on to procedure.
Oracle procedure gets input value, run query and logs everything in the logfile.
I'm facing with couple of challenges
1. Even though I pass all... (5 Replies)
Discussion started by: homer4all
5 Replies
3. Shell Programming and Scripting
Friends,
I'm newbie with ksh so wanting some help....
1. I'm trying to call oracle stored procedure from ksh script by taking variable value from runtime, feed into script and execute procedure.
2. Put name1 and name2 value from script run replacing $3 & $4
I'm trying to put name1 in... (4 Replies)
Discussion started by: homer4all
4 Replies
4. Shell Programming and Scripting
Hi Everyone,
I want to create a script where i need to run the oracle stored procedure from unix script and get the output(sequence number ) into a variable which i will pass in my datastage job.
Below is my stored procedure:-
DECLARE
P_TRANSTYPE VARCHAR2(20);
... (4 Replies)
Discussion started by: prasson_ibm
4 Replies
5. Shell Programming and Scripting
I have written a stored procedure in oracle database, which is having a CLOB OUT parameter. How can i call this stored procedure from shell script and get the CLOB object in shell script variable? (0 Replies)
Discussion started by: vel4ever
0 Replies
6. Shell Programming and Scripting
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;... (6 Replies)
Discussion started by: barani75
6 Replies
7. Shell Programming and Scripting
Hi
i am calling a stored procedure from unix shell like this call
test_proc('0002','20100218');
the stored procedure was giving output
like this dbms_output.put_line(' processed earlier');
i want to see the output in the unix shell where i called.
Thanks
barani (6 Replies)
Discussion started by: barani75
6 Replies
8. Shell Programming and Scripting
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... (1 Reply)
Discussion started by: mac4rfree
1 Replies
9. Shell Programming and Scripting
Here's a shell script snippet.....
cd $ORACLE_HOME/bin
Retval=`sqlplus -s <<eof
$TPDB_USER/april@$TPD_DBCONN
whenever SQLERROR exit 2 rollback
whenever OSERROR exit 3 rollback
set serveroutput on
set pages 999
var status_desc char(200)
var status_code... (1 Reply)
Discussion started by: hidnana
1 Replies
10. Shell Programming and Scripting
hai,
can anybody say how to call or to execute an oracle stored procedure in oracle from unix...
thanks in advance.... for ur reply....
by,
leo (2 Replies)
Discussion started by: Leojhose
2 Replies
defncopy(1) FreeTDS Utilities defncopy(1)
NAME
defncopy - extract procedures and views from a Microsoft server.
SYNOPSIS
defncopy [-U username] [-P password] [-S server] [-D database]
[-i input_file] [-o output_file] [-v]
[owner.]object_name [[owner.]object_name...]
DESCRIPTION
defncopy is a utility program distributed with FreeTDS. It replaces a similar program of the same name distributed by Sybase.
defncopy reads the text of a stored procedure or view, and writes a script suitable for recreating the procedure or view. For tables, it
reads the output of sp_help and constructs a CREATE TABLE statement, complete with CREATE INDEX, too.
OBJECTS
owner is optional if you or the database owner is the owner of the procedure/view being copied.
object_name
is the name of the system object you wish to extract.
OPTIONS
-U username
database server login name.
-P password
database server password.
-S server
database server to which to connect.
-D database
database to use. Optional if the procedure/view being extracted is in your default database.
-i input_file
a script to apply to the database. Not currently implemented.
-o output_file
a file to hold the script, defaults to standard output.
-v Show version information and copyright notice.
NOTES
defncopy is a filter; it reads from standard input, writes to standard output, and writes errors to standard error. The -i and -o options
override these, of course.
defncopy makes use of the db-lib API provided by FreeTDS. This API is of course also available to application developers.
EXIT STATUS
defncopy exits 0 on success, and >0 if the server cannot process the query.
defncopy will report any errors returned by the server, but will continue processing.
HISTORY
defncopy first appeared in FreeTDS 0.63.
AUTHORS
The defncopy utility was written by James K. Lowden <jklowden@schemamania.org>
BUGS
Works only with Microsoft servers and ancient Sybase servers.
Does not create primary keys.
Many options are defined by Sybase that this version does not implement. Feel free to correct this situation.
In theory, defncopy could apply/produce DDL for any system object, but at present only tables, procedures and views are supported, and only
for extraction.
doc 13 November 2011 defncopy(1)