How to use unix cell scripting [message #628215] |
Fri, 21 November 2014 06:19 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](//www.gravatar.com/avatar/c825fefef08d11db576e1396a25866cb?s=64&d=mm&r=g) |
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 #628262 is a reply to message #628256] |
Sat, 22 November 2014 03:12 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8964 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
aaditya321 wrote on Sat, 22 November 2014 07:14Now 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 #628413 is a reply to message #628410] |
Tue, 25 November 2014 00:09 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](/forum/images/custom_avatars/72104.gif) |
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.
|
|
|