Passing a value to stored procedure from unix shell script
Hi Dudes
I want a unix shell script to pass value to SQL stored procedure.
Below is the procedure
Code:
declare
res varchar2(10);
begin
odm_load_check('PRE_SANITY',res);
dbms_output.put_line(res);
end;
select * from error_log;
truncate table error_log;
select * from test;
We have to pass the value to the below procedure in the procedure from a unix script.
Code:
odm_load_check('PRE_SANITY',res);
out put should be like this when we run the script:
enter the value:
value1 #we have to input this value
and then this value1 need to be passed to odm_load_check('PRE_SANITY',res); in the above procedure.Please help me , i need it very urgent
Last edited by pludi; 03-12-2010 at 03:38 AM..
Reason: code tags, please...
Hi All,
This is a very starnge problem I am having. I have a shell script that calls a stored procedure.
Here's my code in shell script:
sqlplus "userid/pwd" @file.sql
and file.sql has the following statement:
exec my_storedProc;
Now, when I execute my shell script, nothing... (2 Replies)
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)
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 (0 Replies)
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)
hi
i am calling a oracle stored procedure(in the database) from unix shell scripting (a.sh).
the called stored procedure returns some values through OUT variables
i want to assign the return values of stored procedure in to unix shell script variable.
can you provide me the code.
... (1 Reply)
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)
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)
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? (6 Replies)
Hello all,
I am trying to run stored procrdure from shell script which takes one argument. And also I want to verify in the script whether the script executed successfully. However the Stored procedure is not running from shell script. Manually if I run it update the data in the table.
Can... (29 Replies)
Discussion started by: PriyaSri
29 Replies
LEARN ABOUT DEBIAN
mojo::message::response
Mojo::Message::Response(3pm) User Contributed Perl Documentation Mojo::Message::Response(3pm)NAME
Mojo::Message::Response - HTTP 1.1 response container
SYNOPSIS
use Mojo::Message::Response;
# Parse
my $res = Mojo::Message::Reponse->new;
$res->parse("HTTP/1.0 200 OKx0ax0d");
$res->parse("Content-Length: 12x0ax0dx0ax0d");
$res->parse("Content-Type: text/plainx0ax0dx0ax0d");
$res->parse('Hello World!');
say $res->body;
# Build
my $res = Mojo::Message::Response->new;
$res->code(200);
$res->headers->content_type('text/plain');
$res->body('Hello World!');
say $res->to_string;
DESCRIPTION
Mojo::Message::Response is a container for HTTP 1.1 responses as described in RFC 2616.
EVENTS
Mojo::Message::Response inherits all events from Mojo::Message.
ATTRIBUTES
Mojo::Message::Response inherits all attributes from Mojo::Message and implements the following new ones.
"code"
my $code = $res->code;
$res = $res->code(200);
HTTP response code.
"message"
my $message = $res->message;
$res = $res->message('OK');
HTTP response message.
METHODS
Mojo::Message::Response inherits all methods from Mojo::Message and implements the following new ones.
"cookies"
my $cookies = $res->cookies;
$res = $res->cookies(Mojo::Cookie::Response->new);
$res = $res->cookies({name => 'foo', value => 'bar'});
Access response cookies, usually Mojo::Cookie::Response objects.
say $res->cookies->[1]->value;
"default_message"
my $message = $res->default_message;
Generate default response message for code.
"fix_headers"
$res = $res->fix_headers;
Make sure response has all required headers for the current HTTP version.
"is_status_class"
my $success = $res->is_status_class(200);
Check response status class.
SEE ALSO
Mojolicious, Mojolicious::Guides, <http://mojolicio.us>.
perl v5.14.2 2012-09-05 Mojo::Message::Response(3pm)