Home » Infrastructure » Unix » How to use unix cell scripting
How to use unix cell scripting [message #628215] Fri, 21 November 2014 06:19 Go to next message
aaditya321
Messages: 225
Registered: January 2014
Location: Delhi
Senior Member
Hi Guys,

I have created a procedure, please let me know how to use cell scripting in my procedure.

SQL> set SERVEROUTPUT ON
SQL> create or replace procedure S_hello
  2  is
  3     v_string varchar2(256):='Hello India!';
  4  begin
  5     dbms_output.put_line(v_string);
  6  end;
  7  /

Procedure created.



how to execute my procedure in Unix environment.
Re: How to use unix cell scripting [message #628226 is a reply to message #628215] Fri, 21 November 2014 08:40 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
echo "Hello India!"
Re: How to use unix cell scripting [message #628238 is a reply to message #628215] Fri, 21 November 2014 09:51 Go to previous messageGo to next message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
Are you asking how to run a SQL stored procedure from the command prompt on a Unix system?
Re: How to use unix cell scripting [message #628252 is a reply to message #628226] Fri, 21 November 2014 23:09 Go to previous messageGo to next message
aaditya321
Messages: 225
Registered: January 2014
Location: Delhi
Senior Member
BlackSwan wrote on Fri, 21 November 2014 08:40
echo "Hello India!"



Hi Swan,

Still we didn't get, please explain it more that how to write procedure in Unix environment, how to execute and to run procedure in unix environment.
Re: How to use unix cell scripting [message #628254 is a reply to message #628252] Sat, 22 November 2014 00:31 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You didn't answer gazzag's question.
Do you mean PL/SQL procedure or shell procedure?

Re: How to use unix cell scripting [message #628256 is a reply to message #628254] Sat, 22 November 2014 01:14 Go to previous messageGo to next message
aaditya321
Messages: 225
Registered: January 2014
Location: Delhi
Senior Member
Now I am using these oracle procedure in window operating system, but same oracle procedure I want to use in unix operating then how to do.

[Updated on: Sat, 22 November 2014 01:15]

Report message to a moderator

Re: How to use unix cell scripting [message #628257 is a reply to message #628256] Sat, 22 November 2014 01:15 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You still didn't answer the question.

Re: How to use unix cell scripting [message #628258 is a reply to message #628257] Sat, 22 November 2014 02:38 Go to previous messageGo to next message
aaditya321
Messages: 225
Registered: January 2014
Location: Delhi
Senior Member
I am looking our question's answers.
Re: How to use unix cell scripting [message #628259 is a reply to message #628258] Sat, 22 November 2014 02:49 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You can't have any answer if you don't answer our question as, currently, we don't what you did and what you want.

Re: How to use unix cell scripting [message #628262 is a reply to message #628256] Sat, 22 November 2014 03:12 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
aaditya321 wrote on Sat, 22 November 2014 07:14
Now I am using these oracle procedure in window operating system, but same oracle procedure I want to use in unix operating then how to do.
You want to do something on Unix that you are already doing on Windows. If you show what you are doing on Windows, then perhaps someone can help.

Re: How to use unix cell scripting [message #628264 is a reply to message #628262] Sat, 22 November 2014 03:25 Go to previous messageGo to next message
aaditya321
Messages: 225
Registered: January 2014
Location: Delhi
Senior Member
I am enthusiasm to know more about Unix caused some company hire those person who have pl/sql & unix cell scripting knowledge, I know both but I don't know how to write stored procedure in unix environment. So I need to help from expertise person, who can give my question's answer.
Re: How to use unix cell scripting [message #628265 is a reply to message #628264] Sat, 22 November 2014 03:27 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

There is no stored procedure in Unix shell as there is no stored procedure in Windows shell.
Why don't you answer our questions?

Re: How to use unix cell scripting [message #628268 is a reply to message #628265] Sat, 22 November 2014 03:37 Go to previous messageGo to next message
aaditya321
Messages: 225
Registered: January 2014
Location: Delhi
Senior Member
I feel, due to my lack of knowledge, I am asking so like, but still my doubt is not clear, again we putting my question here.

Now I am using sql*plus oracle 10g in window7 operating system.

But now I want use unix operating system and writing procedure here like window, so need to help how to start procedure code in unix operating system.
Re: How to use unix cell scripting [message #628269 is a reply to message #628268] Sat, 22 November 2014 03:40 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

And we asked you to post your procedure on Windows so we know what you want exactly, for now it is not clear.
So why don't post what we ask?

Re: How to use unix cell scripting [message #628270 is a reply to message #628269] Sat, 22 November 2014 04:00 Go to previous messageGo to next message
aaditya321
Messages: 225
Registered: January 2014
Location: Delhi
Senior Member
My procedure code is on window in sql* plus editor like below.

SQL> set SERVEROUTPUT ON
SQL> create or replace procedure S_hello
  2  is
  3     v_string varchar2(256):='Hello India!';
  4  begin
  5     dbms_output.put_line(v_string);
  6  end;
  7  /

Procedure created.


Now I want to know that how to write same code on unix operating system.
Re: How to use unix cell scripting [message #628271 is a reply to message #628270] Sat, 22 November 2014 04:04 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

This is a PL/SQL procedure, this has nothing to do with Windows, Unix or any OS.
You do it in the same way in any OS, the only change is the editor.

Re: How to use unix cell scripting [message #628272 is a reply to message #628271] Sat, 22 November 2014 04:10 Go to previous messageGo to next message
aaditya321
Messages: 225
Registered: January 2014
Location: Delhi
Senior Member
Please tell me one thing more what is use of unix cell scripting in PL/SQL programming.
Re: How to use unix cell scripting [message #628273 is a reply to message #628272] Sat, 22 November 2014 04:13 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

None.
What is the use of Windows shell in PL/SQL programming?

And this SHell not Cell.
Re: How to use unix cell scripting [message #628289 is a reply to message #628273] Sat, 22 November 2014 10:35 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
https://www.google.com/webhp?hl=en&tab=ww#hl=en&q=unix+c+shell+scripting+tutorial
Re: How to use unix cell scripting [message #628410 is a reply to message #628289] Mon, 24 November 2014 23:40 Go to previous messageGo to next message
aaditya321
Messages: 225
Registered: January 2014
Location: Delhi
Senior Member
My question is how to call procedure in unix cell scripting.
Re: How to use unix cell scripting [message #628412 is a reply to message #628410] Tue, 25 November 2014 00:08 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Sat, 22 November 2014 07:31

You didn't answer gazzag's question.
Do you mean PL/SQL procedure or shell procedure?


This topic goes nowhere, OP does not answer the question and does not even make the effort to properly spell "shell" I lock it.

Re: How to use unix cell scripting [message #628413 is a reply to message #628410] Tue, 25 November 2014 00:09 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Are you allowed to search the Internet? Is Google, Bing or Yahoo blocked where you are located? How do you find any other information (not related to Unix shell (man, you don't know even how to spell it, although you've already being pointed to it) scripting)?

Here's a little tutorial for you, i.e. the way I usually do it. Try to get used to it, it saves you A LOT of time (meaning: if you had done it 4 days ago, you'd already have the answer). So, click here. Watch what's going on. Process the results.

Can't be simpler.
Previous Topic: All pre-req checks failing
Next Topic: RW Converter issue
Goto Forum:
  


Current Time: Thu Mar 28 08:46:49 CDT 2024