[an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] (none) [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] (none) [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive]
 
[an error occurred while processing this directive] [an error occurred while processing this directive]
Skåne Sjælland Linux User Group - http://www.sslug.dk Home   Subscribe   Mail Archive   Forum   Calendar   Search
MhonArc Date: [Date Prev] [Date Index] [Date Next]   Thread: [Date Prev] [Thread Index] [Date Next]   MhonArc
 

Re: [PROGRAMMERING] ODBC og PL/SQL?



-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Sat, 4 Apr 2009 15:08:38 +0200 (CEST)
Jacob Sparre Andersen <sslug@sslug> wrote:

>    »declare
>        ID Papirer.Serie_ID;
>     begin
>        ID := Papirer.Ny_Bloomberg_Serie (...);
>     end;«
> 
Ovenstående kan ikke udføres som SQL. Man skriver sin kode i f.eks.
SQLDeveloper, og vælger at køre sit script. Der sker herefter det, at
Oracle's PL/SQL compiler oversætter din kode til den database, du er
logget ind på, og installere resultatet som en pakke. I ovenstående
tilfælde kan det dog ikke gøres, da du specificerer en anonym procedure.

Jeg har skrevet en lille howto med eksempler, men da det er en smule
omfattende, har jeg lagt det op på min webserver:
http://www.datanom.net/oracle/

> 
> Er det købe-software?  Kan det tænkes at det er noget vores databaseadministratorer allerede har liggende?
>
C++ driveren leveres sammen med serveren, men hvad ADA angår, er jeg
blank. Se mine links nedenfor.

> > Hvilket programmeringssprog anvender du udover PL/SQL?
> 
> Blandt andet Ada og C++.
> 
C/C++:
Anvend blot gcc/g++. Bemærk dog at oci er linket med libstdc++5, og
uden særlige forholdsregler vil man få en mix af delte biblioteker
linket med libstdc++5 og libstdc++6. Dette vil få programmet til at
lave en segfault.

ADA:
http://download.oracle.com/docs/cd/B10501_01/appdev.920/a58231/toc.htm
http://members.tripod.com/vagul/adaoci.html

- -- 
Hilsen/Regards
Michael Rasmussen
http://pgp.mit.edu:11371/pks/lookup?op=get&search=0xE3E80917
A computer is like air conditioning: it becomes useless when you open
windows.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)

iEYEARECAAYFAknX/jMACgkQVErYVePoCReovACeMI1mve965D0KFmfZtEVqd9kN
tTAAniZnBvB5ZKU0liTxK8XrleK67Q7h
=6T0s
-----END PGP SIGNATURE-----


 
Home   Subscribe   Mail Archive   Index   Calendar   Search

 
 
Questions about the web-pages to <www_admin>. Last modified 2009-05-01, 02:01 CEST [an error occurred while processing this directive]
This page is maintained by [an error occurred while processing this directive]MHonArc [an error occurred while processing this directive] # [an error occurred while processing this directive] *