rbatte1, yes $1-4 are just example I showed of what will be runtime parameter will look like... I don't use them in actual script... yes script gets run like
problem is getting back result from stored procedure to display in logfile.
Here's a shell script snippet.....
cd $ORACLE_HOME/bin
Retval=`sqlplus -s <<eof
$TPDB_USER/april@$TPD_DBCONN
whenever SQLERROR exit 2 rollback
whenever OSERROR exit 3 rollback
set serveroutput on
set pages 999
var status_desc char(200)
var status_code... (1 Reply)
Hi
i am calling a stored procedure from unix shell like this call
test_proc('0002','20100218');
the stored procedure was giving output
like this dbms_output.put_line(' processed earlier');
i want to see the output in the unix shell where i called.
Thanks
barani (6 Replies)
Hi
i want to call a oracle stored procedure from unix (using bash shell).
consider this is my oracle stored procedure with parameter
create procedure testproc(name IN varchar, age IN Number, id OUT Number )
AS
begin
id=1;
dbms_output.put.line('successfull validation')
end;... (6 Replies)
Hi,
Can you assist me in how to redirect the output of oracle stored procedure from unix script?
Something similar to what i did for sybase
isql -U$MYDBLOG -D$MYDBNAME -S$MYDBSVR -P$MYDBPWD -o$MYFILE<< %%
proc_my_test 8
go
%%
Thanks in advance - jak (0 Replies)
Hi Everyone,
I want to create a script where i need to run the oracle stored procedure from unix script and get the output(sequence number ) into a variable which i will pass in my datastage job.
Below is my stored procedure:-
DECLARE
P_TRANSTYPE VARCHAR2(20);
... (4 Replies)
Friends,
I'm newbie with ksh so wanting some help....
1. I'm trying to call oracle stored procedure from ksh script by taking variable value from runtime, feed into script and execute procedure.
2. Put name1 and name2 value from script run replacing $3 & $4
I'm trying to put name1 in... (4 Replies)
Discussion started by: homer4all
4 Replies
LEARN ABOUT DEBIAN
renpy
renpy(6) Games renpy(6)NAME
renpy - engine for creating visual novels
SYNOPSIS
renpy [path to the script directory]
DESCRIPTION
Ren'Py is a programming language and runtime, intended to ease the creation of visual-novel type games. It contains features that make it
easy to display thoughts, dialogue, and menus; to display images to the user; to write game logic; and to support the saving and loading of
games.
Ren'Py tries to be like an executable script, allowing you to get a working game without much more effort than is required to type the game
script into the computer.
Ren'Py is implemented on top of python, and that python heritage shows through in many places. Many Ren'Py statements allow python expres-
sions to be used, and there are also Ren'Py statements that allow for the execution of arbitrary python code. Many of the less-used fea-
tures of Ren'Py are exposed to the user by way of python. By only requiring use of the simplest features of python, it's hoped that Ren'Py
will be usable by all game authors.
USAGE
If you run the program without any arguments, zou will get an interactive launcher from where you can select, run and work different
projects.
For running a script, you need to give the full path to the directory that contains the game you want to play.
For example: renpy /usr/share/games/renpy/demo/
To learn how to use the game interface, you should install and play renpy-demo.
FILES
The game data for each user is stored at ~/.renpy/ directory.
The scripts can be installed in the system bz placing them under /usr/share/games/renpy/ , but you can run any script in an arbitrarz
directory just by telling the path as the parameter to the game.
SEE ALSO
You can find more information at http://www.renpy.org/
May 2007 renpy(6)