..... but there is no end, i.e. there is no line which is just ENDOFSQL
You also have connect $LOGIN immediately afterwards, which seems strange as you sign on with your sqlplus command, however I would recommend not putting sqlplus $LOGIN in your cade as a simple ps can reveal your credentials.
Can you consider these points and then also trim your code down to the fewest statements you need to reproduce this condition?
HI,
I have a similar problem to thread 18264, only I couldn't get it to work.
https://www.unix.com/showthread.php?t=18264
I have a stored procedure which is called by a shell script program. When I run the stored procedure alone or through the shell script, it works fine with output text... (3 Replies)
Hi ,
i have created an .sh file that has the following code:
#!/bin/ksh
sqlplus -s p1istuat/p1istuat@CWS_IST6 @Procedure_Execute.sql &
sqlplus -s p1istuat/p1istuat@CWS_IST6 << EOF
exit
EOF
The mentioned Procedure_Execute.sql file inside has the following code:
exec TEST;
... (5 Replies)
HI,
i want to write a script (Linux) that:
1) connect to a database oracle
2) execute some store procedure.
Can anybody help me, please?
Thanks a lot
Andrew (3 Replies)
Hi,
I have a sybase stored procedure which takes two input parameters (start_date and end_date) and when it get executed, it gives few records as an output.
I want to write a unix script (ksh) which login to the sybase database, then execute this stored procedure (takes the input parameter as... (8 Replies)
Hello,
I created a sql file to create a Procedure, and it was successfully created.
I created a sql file to execute the procedure, and it did without any errors, but i dont see the data been updated.
The Execute procedure.sql script is:
BEGIN
set serveroutput on size 1000000
execute... (5 Replies)
Hi Gurus,
Want to execute a shell script from a oracle procedure and get the status of the same, any assistance in this regard will be appreciated.
proc_data.sh is script name which I want to execute from oracle procedure
It should work something like below
procedure test
begin... (1 Reply)
Here is the shell script which need to trigger a stored procedure and when the record count is 0 then it should capture in the log that 0 duplicate records are found and if it's more than 0 then log with no of records. Also if there is any sqlerror then it should write the same in the log file and... (17 Replies)
Discussion started by: senmng
17 Replies
LEARN ABOUT OSX
logwtmp
LOGIN(3) BSD Library Functions Manual LOGIN(3)NAME
login, logout, logwtmp -- login utility functions (DEPRECATED)
SYNOPSIS
#include <util.h>
void
login(struct utmp *ut);
int
logout(const char *line);
void
logwtmp(const char *line, const char *name, const char *host);
DESCRIPTION
The login(), logout(), and logwtmp() functions are DEPRECATED; use pututxline(3) instead.
These functions operate on the database of current users in /var/run/utmpx and the system log file. Superuser permission is required.
The login() function updates the /var/run/utmpx files with user information contained in ut (after converting to a struct utmpx, as described
in pututxline(3)).
The logout() function removes the entry from /var/run/utmpx corresponding to the device line.
The logwtmp() function adds an entry to the system log file. Since login() will add the appropriate entry during a login, logwtmp() is usu-
ally used for logouts.
RETURN VALUES
logout() returns non-zero if it was able to find and delete an entry for line, and zero if there is no entry for line in /var/run/utmpx.
However, there is no error indication due to lack of permissions.
FILES
/dev/*
/var/run/utmpx
SEE ALSO pututxline(3), utmp(5), utmpx(5)BSD December 14, 1995 BSD