| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: writing libs (.so) for oracel enterprise on linux
Pro*C
-----Original Message-----
From: Josef Kropf [mailto:jose_at_vossen.com]
Sent: Thursday, May 18, 2000 4:45 AM
To: Multiple recipients of list ORACLE-L
Subject: writing libs (.so) for oracel enterprise on linux
hello community,
sorry if this =EDs a stupid question, but i need to write some =
external
procedures for oracle 8.0.5 enterprise on linux (is it right that they =
are
faster than stored procs, especially when they are filled with =
mathematic
formulas?)
i use the gcc - compiler, how can i send a select statement to my =
database
and put the retrieved data into an array
like select * from packings into :pack.obj_id, :pack.name, =
:pack.volume,
:pack.weight;
then i get all the goods from a specific delivery with another select =
into
another array.
after processing data and packing everything, i want to insert it back =
into
another table, but don't know how...
background is, i want to pack our goods into multiple packings, there =
are
customers with special packings and so on
after calculating the best variant i want to write that stuff back in a
temporary table which i use to print the packing lists on a terminal =
server
processing an jobqueue.
i've been playing around with this for more than two weeks now and =
can't get
any further...
thank you for every little hint
jk
--
J. Kropf
Vossen Headquarters, Central Data Processing
www.vossen.com
** carpe noctem **
--=20
Author: Josef Kropf
INET: jose_at_vossen.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu May 18 2000 - 07:33:11 CDT
 |
 |