| Bind var : : sql error, ORA-01008: not all variables bound [message #100753] |
Fri, 01 August 2003 02:06  |
tri mariono
Messages: 2
Registered: August 2003
|
Junior Member |
|
|
i have code in asp :
<%
Sql = "Select * from m_buku"
Set rs = OraDB.DbCreateDynaset(sql,Cint(0))
do while Not rs.eof
vBuku = rs("induk")
rs.movenext
loop
OraDb.Parameters.add "var1", 0, 1
' *** this is line 132 ***'
SqlPinjam = "SELECT * FROM B_PINJAM B_PINJAM , B_Buku WHERE (B_BUKU.INDUK = :"& var1&")"
Set rsPinjam = Oradb.DbCreateDynaset(sqlPinjam, cint(0))
do while Not rsPinjam.eof
pinjam = rsPinjam(0)
rsPinjam.movenext
loop
%>
But i get error in browser :
Oracle Automation error '800a01b8'
SQL execution error, ORA-01008: not all variables bound
pus_Rinci.asp, line 133
|
|
|
|
| Re: Bind var : : sql error, ORA-01008: not all variables bound [message #100754 is a reply to message #100753] |
Fri, 01 August 2003 02:14  |
tri mariono
Messages: 2
Registered: August 2003
|
Junior Member |
|
|
I'm sorry this is my code :
Sql = "Select * From B_Buku"
Set rs = OraDB.DbCreateDynaset(sql,Cint(0))
Do While Not Rs.EOF
var1 = Rs(0)
Rs.MoveNext
Loop
OraDb.Parameters.add "var1", 0, 1
'**this line 132'
SqlPinjam = "SELECT * from pengolahan, b_Buku where(B_BUKU.INDUK = :"& var1&")"
Set rsPinjam = Oradb.DbCreateDynaset(sqlPinjam, cint(0))
do while Not rspinjam.eof
vPeminjam = RsPinjam(2)
rsPinjam.movenext
loop
|
|
|
|
| Re: Bind var : : sql error, ORA-01008: not all variables bound [message #101315 is a reply to message #100753] |
Tue, 03 August 2004 20:01 |
iroshan
Messages: 1
Registered: August 2004
|
Junior Member |
|
|
Oradatabase.Parameters.Add "SVRNO ", strsvrno, 1
Oradatabase.Parameters.Add "F1250", strf1250, 1
Oradatabase.Parameters.Add "CDATE", strdate, 1
Oradatabase.Parameters.Add "MEDAL", strmedal, 1
Oradatabase.Parameters.Add "BRANCH", strbranch, 1
Oradatabase.Parameters.Add "RANK", strRank, 1
OraSession.DbBeginTrans
Oradatabase.dbexecutesql ("BEGIN INSERT_OFFEMP (:SVRNO,:F1250,:CDATE,:MEDAL,:BRANCH,:RANK);END;")
Oradatabase.Parameters.Remove "SVRNO "
Oradatabase.Parameters.Remove "F1250"
Oradatabase.Parameters.Remove "CDATE"
Oradatabase.Parameters.Remove "MEDAL"
Oradatabase.Parameters.Remove "BRANCH"
Oradatabase.Parameters.Remove "RANK"
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
