11-19-2008
chk ur sqlplus
check whether its istalled or not
you can use command
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
I am using sqlplus.
I have the stored procedure name.
How can i print the stored procedure content? (2 Replies)
Discussion started by: kamil
2 Replies
2. UNIX for Dummies Questions & Answers
Does anyone know how to call an Oracle stored procedure from a Unix script? (1 Reply)
Discussion started by: ssmiths001
1 Replies
3. Shell Programming and Scripting
using the script below I want to pass a parameters thorugh my sql
call(@/unixsxxx/xxxx/helpenv.sql emptab ) as input into an oracle procedure xxxx_package.proc1(%1,emptab); . I tried %1 but it does not work. Any suggestions.
#!bin/ksh
set -x
#
export... (0 Replies)
Discussion started by: TimHortons
0 Replies
4. Shell Programming and Scripting
Hello,
I created a sql file to create a Procedure, and it was successfully created.
I created a sql file to execute the procedure, and it did without any errors, but i dont see the data been updated.
The Execute procedure.sql script is:
BEGIN
set serveroutput on size 1000000
execute... (5 Replies)
Discussion started by: msrahman
5 Replies
5. Shell Programming and Scripting
Hi,
Below is the code to execute the procedure "dbms_job.broken" from the shell script.
on executing manually, it works properly without any error.
but it is not working when scheduled using the cronjob.
#!/usr/bin/bash
user_name="oracdb"
password="ora123"
tns="localdb"... (2 Replies)
Discussion started by: milink
2 Replies
6. Shell Programming and Scripting
Hi,
I want to have a automted script to exceute 20 procedures one by one.
Suppose below is one procedure once it get executed script will write
"PL/SQL procedure successfully completed." to a log
for ex-
exec dbms_stats.gather_table_stats();
Now later procedure starts executing... (1 Reply)
Discussion started by: sv0081493
1 Replies
7. Programming
HI All ,
I am new to oracle procedures. Please help me for the approach to satify the requirement.
I need to create procedures. with parameters passed ( say report,type,identities,country )
It should also call sql query within the procedures and passed parameters should be used in where clause... (2 Replies)
Discussion started by: Perlbaby
2 Replies
8. Shell Programming and Scripting
Hi all,
My oracle procedure returns more than one value.
i need to get one value at a time upto ending value ina shell script.
Please help me..... (9 Replies)
Discussion started by: pmreddy
9 Replies
9. Shell Programming and Scripting
hi all,
i have a unix script where i am calling a database procedure from it. while executing the procedure i am getting an error:
but when i tried to call the same procedure manually then it ran successfully, i goggled this issue and found timezone.dat file missing at... (0 Replies)
Discussion started by: lovelysethii
0 Replies
10. Shell Programming and Scripting
below code is not executing the stored procedure,not sure what the issue.Even sqllog is blank.please help me its very urgent.
sqlplus -s $connect_str@$DB_ORACLE_SID >> ${SQL_LOG_FILE} << EOF
set serverout on
set feed off
set head off
set pages 0
set colsep ,
set tab off
set lin 150... (3 Replies)
Discussion started by: katakamvivek
3 Replies
LEARN ABOUT MOJAVE
encode::gsm0338
Encode::GSM0338(3pm) Perl Programmers Reference Guide Encode::GSM0338(3pm)
NAME
Encode::GSM0338 -- ESTI GSM 03.38 Encoding
SYNOPSIS
use Encode qw/encode decode/;
$gsm0338 = encode("gsm0338", $utf8); # loads Encode::GSM0338 implicitly
$utf8 = decode("gsm0338", $gsm0338); # ditto
DESCRIPTION
GSM0338 is for GSM handsets. Though it shares alphanumerals with ASCII, control character ranges and other parts are mapped very
differently, mainly to store Greek characters. There are also escape sequences (starting with 0x1B) to cover e.g. the Euro sign.
This was once handled by Encode::Bytes but because of all those unusual specifications, Encode 2.20 has relocated the support to this
module.
NOTES
Unlike most other encodings, the following aways croaks on error for any $chk that evaluates to true.
$gsm0338 = encode("gsm0338", $utf8 $chk);
$utf8 = decode("gsm0338", $gsm0338, $chk);
So if you want to check the validity of the encoding, surround the expression with "eval {}" block as follows;
eval {
$utf8 = decode("gsm0338", $gsm0338, $chk);
};
if ($@){
# handle exception here
}
BUGS
ESTI GSM 03.38 Encoding itself.
Mapping x00 to '@' causes too much pain everywhere.
Its use of x1b (escape) is also very questionable.
Because of those two, the code paging approach used use in ucm-based Encoding SOMETIMES fails so this module was written.
SEE ALSO
Encode
perl v5.18.2 2014-01-06 Encode::GSM0338(3pm)