oracle 11g proc c,Solaris 10上 Oracle 11G proc 的C程序示例(转)

/

export

/

home

/

zhangll

/

NetBeansProjects

/

CDS

-

JAL で

"/export/home/data/sunstudio12.1/bin/dmake -f Makefile CONF=Debug"

を実行中

dmake

:

并列モードをデフォルトとして使用します。

.

dmakerc ファイルの设定については、dmake

(

1

)

のマニュアルページを参照してください。

gmake

-

C

./

sample

.

build

-

pre

gmake

[

1

]:

Entering directory `

/

export

/

home

/

zhangll

/

NetBeansProjects

/

CDS

-

JAL

/

sample

'

#proc INCLUDE=./inc LTYPE=NONE HEADER=hdr INAME=inc/jal_types.h

proc INCLUDE=./inc LTYPE=NONE CHAR_MAP=STRING INAME=src/DBSelect1.sc

Pro*C/C++: Release 11.2.0.1.0 - Production on Wed Jul 14 17:06:09 2010

Copyright (c) 1982, 2009, Oracle

and/or its affiliates. All rights reserved.

System default option values taken from: /export/home/oracle

/oracle

11g/db_1/precomp/admin/pcscfg.cfg

proc INCLUDE=./inc LTYPE=NONE CHAR_MAP=STRING INAME=src/DBSelect2.sc

Pro*C/C++: Release 11.2.0.1.0 - Production on Wed Jul 14 17:06:09 2010

Copyright (c) 1982, 2009, Oracle

and/or its affiliates. All rights reserved.

System default option values taken from: /export/home/oracle

/oracle

11g/db_1/precomp/admin/pcscfg.cfg

proc INCLUDE=./inc LTYPE=NONE CHAR_MAP=STRING INAME=src/DBSelect3.sc

Pro*C/C++: Release 11.2.0.1.0 - Production on Wed Jul 14 17:06:09 2010

Copyright (c) 1982, 2009, Oracle

and/or its affiliates. All rights reserved.

System default option values taken from: /export/home/oracle

/oracle

11g/db_1/precomp/admin/pcscfg.cfg

gmake[1]: Leaving directory `/export/home/zhangll/NetBeansProjects/CDS-JAL/sample'

JAL001

-->

1 个のジョブ

JAL001

-->

2 个のジョブ

gmake

-

f nbproject

/

Makefile

-

Debug

.

mk SUBPROJECTS

=

.

build

-

conf

gmake

[

1

]:

Entering directory `

/

export

/

home

/

zhangll

/

NetBeansProjects

/

CDS

-

JAL

'

gmake -f nbproject/Makefile-Debug.mk dist/Debug/GNU-Solaris

-x86/cds-jal

gmake[2]: Entering directory `/export/home/zhangll/NetBeansProjects/CDS-JAL'

mkdir

-

p build

/

Debug

/

GNU

-

Solaris

-

x86

/

sample

/

src

rm

-

f build

/

Debug

/

GNU

-

Solaris

-

x86

/

sample

/

src

/

DBSelect3

.

o

.

d

gcc

-

m32

-

I

./

sample

/

inc

-

L

/

export

/

home

/

oracle

/

oracle

11g

/

db_1

/

lib32

-

lclntsh

-

c

-

g

-

MMD

-

MP

-

MF build

/

Debug

/

GNU

-

Solaris

-

x86

/

sample

/

src

/

DBSelect3

.

o

.

d

-

o build

/

Debug

/

GNU

-

Solaris

-

x86

/

sample

/

src

/

DBSelect3

.

o sample

/

src

/

DBSelect3

.

c

gcc

:

-

lclntsh

:

リンクが完了しなかったのでリンカの入力ファイルは使われませんでした

mkdir

-

p build

/

Debug

/

GNU

-

Solaris

-

x86

/

sample

/

src

rm

-

f build

/

Debug

/

GNU

-

Solaris

-

x86

/

sample

/

src

/

DBSelect2

.

o

.

d

gcc

-

m32

-

I

./

sample

/

inc

-

L

/

export

/

home

/

oracle

/

oracle

11g

/

db_1

/

lib32

-

lclntsh

-

c

-

g

-

MMD

-

MP

-

MF build

/

Debug

/

GNU

-

Solaris

-

x86

/

sample

/

src

/

DBSelect2

.

o

.

d

-

o build

/

Debug

/

GNU

-

Solaris

-

x86

/

sample

/

src

/

DBSelect2

.

o sample

/

src

/

DBSelect2

.

c

gcc

:

-

lclntsh

:

リンクが完了しなかったのでリンカの入力ファイルは使われませんでした

mkdir

-

p build

/

Debug

/

GNU

-

Solaris

-

x86

/

sample

/

src

rm

-

f build

/

Debug

/

GNU

-

Solaris

-

x86

/

sample

/

src

/

DBSelect1

.

o

.

d

gcc

-

m32

-

I

./

sample

/

inc

-

L

/

export

/

home

/

oracle

/

oracle

11g

/

db_1

/

lib32

-

lclntsh

-

c

-

g

-

MMD

-

MP

-

MF build

/

Debug

/

GNU

-

Solaris

-

x86

/

sample

/

src

/

DBSelect1

.

o

.

d

-

o build

/

Debug

/

GNU

-

Solaris

-

x86

/

sample

/

src

/

DBSelect1

.

o sample

/

src

/

DBSelect1

.

c

gcc

:

-

lclntsh

:

リンクが完了しなかったのでリンカの入力ファイルは使われませんでした

mkdir

-

p dist

/

Debug

/

GNU

-

Solaris

-

x86

gcc

-

m32

-

I

./

sample

/

inc

-

L

/

export

/

home

/

oracle

/

oracle

11g

/

db_1

/

lib32

-

lclntsh

-

o dist

/

Debug

/

GNU

-

Solaris

-

x86

/

cds

-

jal build

/

Debug

/

GNU

-

Solaris

-

x86

/

sample

/

src

/

main

.

o build

/

Debug

/

GNU

-

Solaris

-

x86

/

sample

/

src

/

DBSelect3

.

o build

/

Debug

/

GNU

-

Solaris

-

x86

/

sample

/

src

/

DBSelect2

.

o build

/

Debug

/

GNU

-

Solaris

-

x86

/

sample

/

src

/

DBSelect1

.

o build

/

Debug

/

GNU

-

Solaris

-

x86

/

sample

/

src

/

FileIO

.

o

gmake

[

2

]:

Leaving directory `

/

export

/

home

/

zhangll

/

NetBeansProjects

/

CDS

-

JAL

'

gmake[1]: Leaving directory `/export/home/zhangll/NetBeansProjects/CDS-JAL'

构筑 成功。 终了値 0。

/

export

/

home

/

zhangll

/

NetBeansProjects

/

CDS

-

JAL で

"/export/home/zhangll/NetBeansProjects/CDS-JAL/dist/Debug/GNU-Solaris

-x86/cds-jal"

を実行中

----------------------------

select01

()

ename

=

[

FORD

]

----------------------------

select02

()

empno ename job mgr hirdate sal comm deptno

7902 FORD ANALYST 7566 1981

/

12

/

03 00

:

00

:

00 3000

.

00

-

99999

.

99 20

----------------------------

select03

()

empno ename job mgr hirdate sal comm deptno

7369 SMITH CLERK 7902 1980

/

12

/

17 00

:

00

:

00 800

.

00

-

99999

.

99 20

7499 ALLEN SALESMAN 7698 1981

/

02

/

20 00

:

00

:

00 1600

.

00 300

.

00 30

7521 WARD SALESMAN 7698 1981

/

02

/

22 00

:

00

:

00 1250

.

00 500

.

00 30

7566 JONES MANAGER 7839 1981

/

04

/

02 00

:

00

:

00 2975

.

00

-

99999

.

99 20

7654 MARTIN SALESMAN 7698 1981

/

09

/

28 00

:

00

:

00 1250

.

00 1400

.

00 30

7698 BLAKE MANAGER 7839 1981

/

05

/

01 00

:

00

:

00 2850

.

00

-

99999

.

99 30

7782 CLARK MANAGER 7839 1981

/

06

/

09 00

:

00

:

00 2450

.

00

-

99999

.

99 10

7788 SCOTT ANALYST 7566 1987

/

04

/

19 00

:

00

:

00 3000

.

00

-

99999

.

99 20

7839 KING PRESIDENT

-

9999 1981

/

11

/

17 00

:

00

:

00 5000

.

00

-

99999

.

99 10

7844 TURNER SALESMAN 7698 1981

/

09

/

08 00

:

00

:

00 1500

.

00 0

.

00 30

7876 ADAMS CLERK 7788 1987

/

05

/

23 00

:

00

:

00 1100

.

00

-

99999

.

99 20

7900 JAMES CLERK 7698 1981

/

12

/

03 00

:

00

:

00 950

.

00

-

99999

.

99 30

7902 FORD ANALYST 7566 1981

/

12

/

03 00

:

00

:

00 3000

.

00

-

99999

.

99 20

7934 MILLER CLERK 7782 1982

/

01

/

23 00

:

00

:

00 1300

.

00

-

99999

.

99 10

実行 成功。 终了値 0。