02-28-2014
Stored procedures are also a possibility.
9 More Discussions You Might Find Interesting
1. Solaris
All,
We are contemplating a port of an existing software product and would like to expend as little effort as possible. Our new database would be MS-SQL, and we would write stored procedures to perform common db operations. We'd like to call these stored procedures from C or C++ code running... (3 Replies)
Discussion started by: mparks
3 Replies
2. Shell Programming and Scripting
Hi-
I am trying to achieve the following in a script so I can schedule it on a cron job. I am fairly new to the unix environment...
I have written a shell script that reads a flat file and loads the data into an Oracle table (Table1) via SQLLDR. This Works fine. Then, I run a nested insert... (5 Replies)
Discussion started by: rajagavini
5 Replies
3. Shell Programming and Scripting
Hi all,
I have sql query as follows. Please write a pro*c program for the following query.
select
sp1.cost_change
||','|| sp1.cost_change_desc
||','|| sp1.reason
||','|| to_char(sp1.active_date,'DD-MON-YYYY HH24:MI:SS')
||','|| sp1.status
||','|| sp1.cost_change_origin... (0 Replies)
Discussion started by: user71408
0 Replies
4. UNIX for Dummies Questions & Answers
Hi All,
I have written 4 SQL queries. I want to write PRO*C program for this. I want to put these 4 queries in a single PR*C program using threading concept. Please guide me to write the pogram.
the queries are as follows.
1. select * from head;
2. select * from details;
3. delete from head... (0 Replies)
Discussion started by: user71408
0 Replies
5. UNIX for Dummies Questions & Answers
Hi guys,
I am new on here, I have a function in oracle that returns a specific value:
create or replace
PACKAGE BODY "CTC_ASDGET_SCHED" AS
FUNCTION FN_ASDSCHEDULE_GET
RETURN VARCHAR2
AS
BEGIN
DECLARE
ASDSchedule varchar2(6);
ASDComplete... (1 Reply)
Discussion started by: reptile
1 Replies
6. Shell Programming and Scripting
Hi!
I would like to do a single connection to sqlplus and execute some querys.
Actually I do for every query one connection to database
i.e
echo 'select STATUS from v$instance;
exit' > $SQL_FILE
sqlplus user/pass@sid @$SQL_FILE > $SELECT_RESULT
echo 'select VERSION from v$instance;... (6 Replies)
Discussion started by: guif
6 Replies
7. UNIX for Advanced & Expert Users
Hi Experts:
I have a shell script that's kicked off by cron. Inside this shell script, I need to kick off two or more oracle sql scripts to process different groups of tables. And when both sql scripts are done, I will continue in the shell script to do other things like checking processing... (3 Replies)
Discussion started by: huasheng8
3 Replies
8. Shell Programming and Scripting
Hello,
I have a Pro*C program which contains SQL sentences, such as:
....
Pro*C sentences
....
/*SQL 1*/
EXEC SQL SELECT t1.field1, t1.field2
INTO :w_field
FROM TABLE1 t1, TABLE1 t2
WHERE t1.field1 = t2.field1
AND t1.ID = :wl_id;
....
Pro*C sentences
....
/*SQL 1*/
EXEC... (11 Replies)
Discussion started by: mvalonso
11 Replies
9. Shell Programming and Scripting
Hi All,
I want to run multiple sql queries and store the data in variable but i want to use sql command only once. Is there a way without running sql command twice and storing.Please advise.
Eg :
Select 'Query 1 output' from dual;
Select 'Query 2 output' from dual;
I want to... (3 Replies)
Discussion started by: Rokkesh
3 Replies
LEARN ABOUT OSF1
xtremoveallcallbacks
XtAddCallback(3Xt) XtAddCallback(3Xt)
NAME
XtAddCallback, XtAddCallbacks, XtRemoveCallback, XtRemoveCallbacks, XtRemoveAllCallbacks - add and remove callback procedures
SYNOPSIS
void XtAddCallback(w, callback_name, callback, client_data)
Widget w;
String callback_name;
XtCallbackProc callback;
XtPointer client_data;
void XtAddCallbacks(w, callback_name, callbacks)
Widget w;
String callback_name;
XtCallbackList callbacks;
void XtRemoveCallback(w, callback_name, callback,client_data)
Widget w;
String callback_name;
XtCallbackProc callback;
XtPointer client_data;
void XtRemoveCallbacks(w, callback_name, callbacks)
Widget w;
String callback_name;
XtCallbackList callbacks;
void XtRemoveAllCallbacks(w, callback_name)
Widget w;
String callback_name;
ARGUMENTS
Specifies the callback procedure. Specifies the null-terminated list of callback procedures and corresponding client data. Specifies the
callback list to which the procedure is to be appended or deleted. or the client data to match on the registered callback procedures Speci-
fies the argument that is to be passed to the specified procedure when it is invoked by XtCallbacks or NULL, or the client data to match on
the registered callback procedures. Specifies the widget.
DESCRIPTION
The XtAddCallback function adds the specified callback procedure to the specified widget's callback list.
The XtAddCallbacks add the specified list of callbacks to the specified widget's callback list.
The XtRemoveCallback function removes a callback only if both the procedure and the client data match.
The XtRemoveCallbacks function removes the specified callback procedures from the specified widget's callback list.
The XtRemoveAllCallbacks function removes all the callback procedures from the specified widget's callback list.
SEE ALSO
XtCallCallbacks(3Xt)
X Toolkit Intrinsics -- C Language Interface
Xlib -- C Language X Interface
XtAddCallback(3Xt)