|
|
Sponsored Content
Top Forums
UNIX for Dummies Questions & Answers
Unix Shell Scripting( Calling from Unix to PLSQL)
Post 302675225 by faizsaadq on Sunday 22nd of July 2012 11:34:41 AM
07-22-2012
Unix Shell Scripting( Calling from Unix to PLSQL)
Hello Experts,
I have the following questions to be discussed here at this esteemed discussion forum.
I have two Excel sheets which contain Unix Commands llike creating directory the structure/ftp/Copy/Zip etc to basically create an environment. I need help in understanding some of these commands which are basic to many of the experts like you.
My question is ,
1) I am trying to pass a variable through the Excel file to PLSQL packages. How can I declare variables in the Excel file in such a way that I can pass these as parameters to the PLSQL Package without any hard coding involved.
Regards
Fm
I have the following questions to be discussed here at this esteemed discussion forum.
I have two Excel sheets which contain Unix Commands llike creating directory the structure/ftp/Copy/Zip etc to basically create an environment. I need help in understanding some of these commands which are basic to many of the experts like you.
My question is ,
1) I am trying to pass a variable through the Excel file to PLSQL packages. How can I declare variables in the Excel file in such a way that I can pass these as parameters to the PLSQL Package without any hard coding involved.
| Moderator's Comments: | ||
|
Regards
Fm
Last edited by jim mcnamara; 07-22-2012 at 04:44 PM..
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Unix Gurus,
I have been breaking my head to get this done..seems simple..
I need to read a flat file and based on a key word in a line, i need to skip the previous 3 lines.
eg :
Line1
Line2
Line3
Line4
Line5
Line6
Error
Line7
Line8
Line9
Error
Line10 (4 Replies)
Discussion started by: ravred
4 Replies
2. UNIX for Advanced & Expert Users
Could anyone please help me. I have a function in plsql that returns a number. But i am listing some records through that function using DBMS_OUTPUT.PUT_LINE. I want to catch those records by executing this function through a unix script. The following shows what i did
echo "Connected from... (2 Replies)
Discussion started by: cobroraj
2 Replies
3. Programming
Hi can anyone help me in
how to
1) invoke batch profile to run sqlplus on XXXXX server.
2) execute truncate table xtra.xtra_card_email_request using procedure dbadmin.truncate_table .
3) Check the count before and after the job run. (1 Reply)
Discussion started by: jakred
1 Replies
4. Shell Programming and Scripting
how to
1) invoke batch profile to run sqlplus on XXXXX server.
2) execute truncate table xtra.xtra_card_email_request using procedure dbadmin.truncate_table .
3) Check the count before and after the job run. (1 Reply)
Discussion started by: jakred
1 Replies
5. UNIX for Advanced & Expert Users
Hi
Can anyone please let me know how to call unix scripts from sql or plsql ASAP. (2 Replies)
Discussion started by: ksailesh
2 Replies
6. Programming
Hi All,
I am supposed to present the documentation for the PLSQL code (PACKAGES, PROCEDURE, FUNCTIONS) of my application. There are sufficient comments in my code. Has anyone written any Shell Script Utility which can parse the PLSQL code and generate some kind of document ( preferrably HTML not... (1 Reply)
Discussion started by: gauravsachan
1 Replies
7. Shell Programming and Scripting
what is the maximum length of a unix shell variable which can be can passed to plsql variable:( (1 Reply)
Discussion started by: alokjyotibal
1 Replies
8. Shell Programming and Scripting
Hi Friends,
Need your help . I have a shell script which executes the plsql procedure proc_p1.
I want to capture the error message when the procuder throws some error message.
I codeed in the following way . But it shows Job Success. Kindly anyone give some better idea to over come this
... (2 Replies)
Discussion started by: imipsita.rath
2 Replies
9. Shell Programming and Scripting
I am working in production support in an leading bank and more of my job is more in oracle/plsql. I am learning unix shell scripting and have started development in the same.I would like to know regarding the scope of these two in the industry.Also would like to know about other scripting... (2 Replies)
Discussion started by: jesthomas
2 Replies
10. Shell Programming and Scripting
I have a plsql procedure inside a package which is having one IN parameter .I want to call that procedure through a shell script and that IN parameter is a column of a table in the database. So my requirement is that i need to loop all the entries of that IN parameter from the table through shell... (4 Replies)
Discussion started by: rspnf
4 Replies
LEARN ABOUT DEBIAN
excel::template::container::keepleadingzeros
Excel::Template::Container::KeepLeadingZeros(3pm) User Contributed Perl Documentation Excel::Template::Container::KeepLeadingZeros(3pm) NAME
Excel::Template::Container::KeepLeadingZeros - Excel::Template::Container::KeepLeadingZeros PURPOSE
To set the keep_leading_zeros flag for the surrounding worksheet or any worksheets that might be contained within this node. NODE NAME
KEEP_LEADING_ZEROS INHERITANCE
CONTAINER ATTRIBUTES
None CHILDREN
None EFFECTS
Alters how leading zeros are interpreted by Spreadsheet::WriteExcel. DEPENDENCIES
None USAGE
<worksheet> ... Cells here will NOT have leading-zeros preserved <keep_leading_zeros> ... Cells here will have leading-zeros preserved </keep_leading_zeros> ... Cells here will NOT have leading-zeros preserved </worksheet> <keep_leading_zeros> <worksheet> ... Cells here will have leading-zeros preserved </worksheet> <worksheet> ... Cells here will have leading-zeros preserved </worksheet> </keep_leading_zeros> AUTHOR
Rob Kinyon (rob.kinyon@gmail.com) SEE ALSO
CELL, Spreadsheet::WriteExcel perl v5.14.2 2010-06-17 Excel::Template::Container::KeepLeadingZeros(3pm)