OraFAQ Forum: Unix » How to use unix cell scripting

Home » Infrastructure » Unix » How to use unix cell scripting

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to use unix cell scripting [message #628215]

Fri, 21 November 2014 06:19

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.

Code: [Select all] [Show/ hide]

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.

Report message to a moderator

Re: How to use unix cell scripting [message #628226 is a reply to message #628215]

Fri, 21 November 2014 08:40

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

echo "Hello India!"

Report message to a moderator

Re: How to use unix cell scripting [message #628238 is a reply to message #628215]

Fri, 21 November 2014 09:51

gazzag
Messages: 1119
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?

Report message to a moderator

Re: How to use unix cell scripting [message #628252 is a reply to message #628226]

Fri, 21 November 2014 23:09

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.

Report message to a moderator

Re: How to use unix cell scripting [message #628254 is a reply to message #628252]

Sat, 22 November 2014 00:31

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

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

Report message to a moderator

Re: How to use unix cell scripting [message #628256 is a reply to message #628254]

Sat, 22 November 2014 01:14

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

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You still didn't answer the question.

Report message to a moderator

Re: How to use unix cell scripting [message #628258 is a reply to message #628257]

Sat, 22 November 2014 02:38

aaditya321
Messages: 225
Registered: January 2014
Location: Delhi

Senior Member

I am looking our question's answers.

Report message to a moderator

Re: How to use unix cell scripting [message #628259 is a reply to message #628258]

Sat, 22 November 2014 02:49

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

Re: How to use unix cell scripting [message #628262 is a reply to message #628256]

Sat, 22 November 2014 03:12

John Watson
Messages: 8976
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.

Report message to a moderator

Re: How to use unix cell scripting [message #628264 is a reply to message #628262]

Sat, 22 November 2014 03:25

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.

Report message to a moderator

Re: How to use unix cell scripting [message #628265 is a reply to message #628264]

Sat, 22 November 2014 03:27

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

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?

Report message to a moderator

Re: How to use unix cell scripting [message #628268 is a reply to message #628265]

Sat, 22 November 2014 03:37

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.

Report message to a moderator

Re: How to use unix cell scripting [message #628269 is a reply to message #628268]

Sat, 22 November 2014 03:40

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

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?

Report message to a moderator

Re: How to use unix cell scripting [message #628270 is a reply to message #628269]

Sat, 22 November 2014 04:00

aaditya321
Messages: 225
Registered: January 2014
Location: Delhi

Senior Member

My procedure code is on window in sql* plus editor like below.

Code: [Select all] [Show/ hide]

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.

Report message to a moderator

Re: How to use unix cell scripting [message #628271 is a reply to message #628270]

Sat, 22 November 2014 04:04

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

Re: How to use unix cell scripting [message #628272 is a reply to message #628271]

Sat, 22 November 2014 04:10

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.

Report message to a moderator

Re: How to use unix cell scripting [message #628273 is a reply to message #628272]

Sat, 22 November 2014 04:13

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

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

And this SHell not Cell.

Report message to a moderator

Re: How to use unix cell scripting [message #628289 is a reply to message #628273]

Sat, 22 November 2014 10:35

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

Report message to a moderator

Re: How to use unix cell scripting [message #628410 is a reply to message #628289]

Mon, 24 November 2014 23:40

aaditya321
Messages: 225
Registered: January 2014
Location: Delhi

Senior Member

My question is how to call procedure in unix cell scripting.

Report message to a moderator

Re: How to use unix cell scripting [message #628412 is a reply to message #628410]

Tue, 25 November 2014 00:08

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

Re: How to use unix cell scripting [message #628413 is a reply to message #628410]

Tue, 25 November 2014 00:09

Littlefoot
Messages: 21823
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.

Report message to a moderator

Previous Topic:	All pre-req checks failing
Next Topic:	RW Converter issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 03 00:38:51 CDT 2025