...
set conn=Server.CreateObject("ADODB.Connection")
conn.open CONNECTION_STRING
set cmd=Server.CreateObject("ADODB.Command")
set
p1=cmd.CreateParameter("p_jabatan",adVarchar,adParamInput,30,request.form("JABATAN"))
cmd.parameters.append p1
set cmd.activeconnection=conn
cmd.commandText="{Call get_gaji(?)}"
cmd.execute
...
~semoga membantu
FAJAR SIDIK <[EMAIL PROTECTED]> wrote:
Guys .. help me plss ...
Saya punya oracle procedure namanya get_gaji yang didalam nya terdapat
query insert berikut :
insert into table_gaji values ('nama','jabatan','nik')
select nama,jabatan,noinduk from master_emp where jabatan='varjabatan';
commit;
Misal nya untuk menarik gaji sesuai jabatan dengan command :
" exec get_gaji(MGR); --> untuk insert gaji manager atau
" exec get_gaji(STAFF); --> untuk insert gaji staff.
Pertanyaannya :
Gimana cara nya saya call procedure tsb ( get_gaji ) dengan parameter yang
di input di form asp page ?
jadi di kolom input nya tinggal saya masukan MGR atau STAFF atau SPV dan
tinggal klik tombol submit ...
plss help me yaks ....
thsk,
-fajar-
---------------------------------
Apakah Anda Yahoo!?
Kunjungi halaman depan Yahoo! Indonesia yang baru!
[Non-text portions of this message have been removed]
---------------------------------
We have the perfect Group for you. Check out the handy changes to Yahoo! Groups.
[Non-text portions of this message have been removed]
--
-----------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/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/indo-oracle/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> 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/
