Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: pl/sql in unix problem
Top Forums Shell Programming and Scripting pl/sql in unix problem Post 302216557 by infyanurag on Sunday 20th of July 2008 04:14:49 AM
Old 07-20-2008
pl/sql in unix problem
hi all
i have written this small code.

sqlplus $schema_name/$passwrd@$instance <<eof
set serveroutput on;
declare
lv_count pls_integer;
lv_option varchar2(20);
begin
select count(*) into lv_count from all_objects where upper(object_name)=upper('$temp_file1');
DBMS_OUTPUT.PUT_LINE(lv_count);
if lv_count = 1 then
DBMS_OUTPUT.PUT_LINE('DO YOU REALLY WANT TO DROP THIS TABLE?');
lv_option:='&option';
if (lv_option = 'y' OR lv_option = 'Y') then
execute IMMEDIATE 'drop table $temp_file1';
end if;
END IF;
end;
/
@$file_name
eof


the problem is it never asks me the value of option.
i want it to ask me the option value and then drop the tabale.

please help.
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Problem with while loop and SQL

Connected to oracle database sqlplus << EOF $CONNECTSTR set heading off set trimspool on set feedback off select ID,DATE from sysadm.TEST where VALUE = 'A' order by ID; value_id = ID value_date = DATE EOF 1. Is it possible to reference the values, ID,DATE in unix shell script. 2.... (20 Replies)
Discussion started by: nandajk
20 Replies

2. Shell Programming and Scripting

sql query problem

Hi, I am passing an argument for the script and that argument values should exist in database. bill_period_input="'""$1""'" bill_period=`sqlplus uname/pwd@dbname <<eof! set verify off set heading off set feedback off select bill_period from bill_period_ref where... (4 Replies)
Discussion started by: ss_ss
4 Replies

3. Shell Programming and Scripting

unix variables from sql / pl/sql

How do I dynamically assign the below output to unix shell variables so I can build a menu in a shell script? Example: var1 = 1 var2= SYSTEM var3 = 2 var4= UNDOTBS1 and so on, then in the shell script I can use the variables to build a menu. set serveroutput on declare... (2 Replies)
Discussion started by: djehres
2 Replies

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... (1 Reply)
Discussion started by: reptile
1 Replies

5. Shell Programming and Scripting

Sql plus problem in unix

I am getting sqlplus not found error while trying to connect to database from unix. my sql plus is present at the location /opt/dbms/app/oracle/product/10.2_Client and i gave in shell script as below. ORACLE_HOME=/opt/dbms/app/oracle/product/10.2_Client export ORACLE_HOME Please help me with... (6 Replies)
Discussion started by: rdhanek
6 Replies

6. Shell Programming and Scripting

Problem in sql loader

Hi Frnds, I wanto load the data thats in data file with comma(,) delimited. it throw this errors SQL*Loader-951: Error calling once/load initialization ORA-00604: error occurred at recursive SQL level 1 ORA-00054: resource busy and acquire with NOWAIT specified Plz look at my file... (3 Replies)
Discussion started by: Gopal_Engg
3 Replies

7. Shell Programming and Scripting

How to use sql data file in unix csv file as input to an sql query from shell

Hi , I used the below script to get the sql data into csv file using unix scripting. I m getting the output into an output file but the output file is not displayed in a separe columns . #!/bin/ksh export FILE_PATH=/maav/home/xyz/abc/ rm $FILE_PATH/sample.csv sqlplus -s... (2 Replies)
Discussion started by: Nareshp
2 Replies

8. Shell Programming and Scripting

problem in SQL query

I used the following code code select * from tablename where columnname Instead of printing the expected output it prints all the files in the present directory since there is a "*" in the code. Is there any way to overcome the problem? Thanks Ananth (2 Replies)
Discussion started by: Ananthdoss
2 Replies

9. UNIX for Dummies Questions & Answers

unix script with SQL statement problem

Hello, I have a script to get the information from database, however, it's look like the loop is not work, can someone help? :confused: echo Input file list to check: read filelist for file in 'cat $filelist.txt' do echo "select FILENAME from FILE_TABLE where filename like '${file}'%;" >>... (9 Replies)
Discussion started by: happyv
9 Replies

10. Shell Programming and Scripting

How can i run sql queries from UNIX shell script and retrieve data into text docs of UNIX?

Please share the doc asap as very urgently required. (1 Reply)
Discussion started by: 24ajay
1 Replies

LEARN ABOUT DEBIAN

cvm-checkpassword

cvm-checkpassword(8)					      System Manager's Manual					      cvm-checkpassword(8)

NAME

       cvm-checkpassword - checkpassword interface for CVM modules

SYNOPSIS

       cvm-checkpassword CVM Command [ arguments ...  ]

DESCRIPTION

	http://cr.yp.to/checkpwd/interface.html
	http://untroubled.org/cvm/cvm.html

       See the above links for details on both the CVM and checkpassword interfaces.  To use this interface with qmail-pop3d(8), use the following
       command line:

	/var/qmail/bin/qmail-popup 
	cvm-checkpassword cvm-unix 
	/var/qmail/bin/qmail-pop3d ./Maildir/

       Note: The default mode of operations for this module is to attempt to split a domain name from the account name.  If this is not desirable,
       set $CVM_ACCOUNT_SPLIT_CHARS to an empty string.

SEE ALSO

       cvm-pwfile(8), cvm-qmail(8), cvm-unix(8), cvm-sql(8), cvm-vmailmgr(8), cvm-benchclient(8), cvm-testclient(8)

	http://untroubled.org/cvm/cvm.html

															      cvm-checkpassword(8)
All times are GMT -4. The time now is 08:27 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy