8 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have a shell script and im trying to call a .sql file. The sql file has a simple Anonymous block.
The code is
shell script
db2 -tvf query.sql
the sql file contains
SET SERVEROUTPUT ON;
BEGIN
call dbms_output.put_line( 'Hello' );
END;
I get the following error
BEGIN... (1 Reply)
Discussion started by: sup
1 Replies
2. Shell Programming and Scripting
Hello,
Here is the code i have written to get the count of a plsql query back to the unix.
function checkforCOIDs
{
countcheck=`sqlplus -s $1/$2@$3
whenever oserror exit sql.oscode rollback
whenever sqlerror exit sql.sqlcode rollback
set serverout on size 2000;
set head off feedback off... (2 Replies)
Discussion started by: santosh2eee
2 Replies
3. Shell Programming and Scripting
Hi,
My requirement is to load a LONG datatype data value from one table to another as direct access does not work (DB: ORACLE).
eg.
SELECT *FROM ALL_VIEWS WHERE TEXT LIKE '%<SEARCH_STRING>%';
As an alternate we are creating a table and trying to insert in it from ALL_VIEWS as direct insert... (2 Replies)
Discussion started by: sanjaydubey2006
2 Replies
4. What is on Your Mind?
Just created an experimental new forum for anonymous posters.
Anonymous Users Forums - The UNIX and Linux Forums
Feel free to comment about it here. (2 Replies)
Discussion started by: Neo
2 Replies
5. Shell Programming and Scripting
Hi All,
i need you help while accessing the value from anonymous PL/SQL block.
Initially our requirement was to get the value from SQL statement. I was doing like...
But now i need to use dbms_application_info.set_module in it. So i have planned to use anonymous block instead of SQL... (2 Replies)
Discussion started by: Amit.Sagpariya
2 Replies
6. UNIX for Dummies Questions & Answers
Could anyone provide information on how to block a specific client machine from being able to log onto anonymous ftp? (10 Replies)
Discussion started by: dennisheazle
10 Replies
7. Cybersecurity
For the last week or so every day for about 6 to 10 hours someone is logging in and out continuously to our anonymous ftp. They don't stay logged in. It seems like it must be an automatic process aimed at tying up our anonymous ftp. The ID of the server doing this is can59-4-82-240-1.
As a result... (2 Replies)
Discussion started by: dennisheazle
2 Replies
8. UNIX for Advanced & Expert Users
Hi,
Can a anonymous user have password ?
I have created a user and set password. Now I want to create that user as anonymous.
Ronald (1 Reply)
Discussion started by: ronald_brayan
1 Replies