aku buat di procedure seperti ini :
...
insert into gaji_dtl(gaji_dtl_id, gaji_id, doc_type_id, jumlah, adjusment,
dk)
select sq_gaji_dtl.nextval,gaji_id,75,jumlah,0,dk
from (select get_gaji_id(arg_tanggal,b.karyawan_id) as gaji_id,
(select sum(a.jumlah+a.adjusment) <-- error disini
from gaji_dtl a,gaji c
where a.gaji_id = c.gaji_id
and to_char(c.tanggal,'mm/yyyy') =
to_char(arg_tanggal,'mm/yyyy')
and c.karyawan_id = b.karyawan_id
and a.dk = 'D') as jumlah,get_name('DK',75) as dk
from karyawan a,gaji b
where a.karyawan_id = b.karyawan_id);
....
Compilation errors for PROCEDURE DBHRMS.PROC_INSERTGAJIDTL
Error: PLS-00103: Encountered the symbol "SELECT" when expecting one of the
following:
( - + mod not null others <an identifier>
<a double-quoted delimited-identifier> <a bind variable> avg
count current exists max min prior sql stddev sum variance
execute forall time timestamp interval date
<a string literal with character set specification>
<a number> <a single-quoted SQL string>
Line: 45
Text: (select sum(a.jumlah+a.adjusment)
ada yang tau gimana caranya supaya tidak error?
thank's
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.blogspot.com
Mirror: http://indooracle.wordpress.com
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.blogspot.com
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indo-oracle/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
