Using Bind Variables in SQL statements from VB to Oracle

EDN Admin

EDN Admin

Well-known member
Joined
Aug 7, 2010
Messages
12,794
Location
In the Machine
I am trying to use Bind Variables in my SQL statements which I pass to an Oracle database, but I get the Oracle error ORA-01008 Not all variables bound.
This is the code I am testing with:-
<span style="font-family:Consolas; font-size:x-small <span style="font-family:Consolas; font-size:x-small <font face="Consolas" size="2" style="font-family:Consolas; font-size:x-small

</font>
<span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small Dim<span style="font-family:Consolas; font-size:x-small <span style="font-family:Consolas; font-size:x-small
cn <span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small As<span style="font-family:Consolas; font-size:x-small <span style="font-family:Consolas; font-size:x-small
ADODB.<span style="font-family:Consolas; color:#2b91af; font-size:x-small

<span style="font-family:Consolas; color:#2b91af; font-size:x-small
<span style="font-family:Consolas; color:#2b91af; font-size:x-small Connection




<span style="font-family:Consolas; font-size:x-small <span style="font-family:Consolas; font-size:x-small <font face="Consolas" size="2" style="font-family:Consolas; font-size:x-small

</font>
<span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small Dim<span style="font-family:Consolas; font-size:x-small <span style="font-family:Consolas; font-size:x-small
rs <span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small As<span style="font-family:Consolas; font-size:x-small <span style="font-family:Consolas; font-size:x-small
ADODB.<span style="font-family:Consolas; color:#2b91af; font-size:x-small

<span style="font-family:Consolas; color:#2b91af; font-size:x-small
<span style="font-family:Consolas; color:#2b91af; font-size:x-small Recordset




<span style="font-family:Consolas; font-size:x-small <span style="font-family:Consolas; font-size:x-small <font face="Consolas" size="2" style="font-family:Consolas; font-size:x-small

</font>
<span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small Dim<span style="font-family:Consolas; font-size:x-small <span style="font-family:Consolas; font-size:x-small
pobparam <span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small As<span style="font-family:Consolas; font-size:x-small <span style="font-family:Consolas; font-size:x-small
ADODB.<span style="font-family:Consolas; color:#2b91af; font-size:x-small

<span style="font-family:Consolas; color:#2b91af; font-size:x-small
<span style="font-family:Consolas; color:#2b91af; font-size:x-small Parameter




<span style="font-family:Consolas; font-size:x-small <span style="font-family:Consolas; font-size:x-small <font face="Consolas" size="2" style="font-family:Consolas; font-size:x-small

</font>
<span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; font-size:x-small

<span style="font-family:Consolas; font-size:x-small


<span style="font-family:Consolas; font-size:x-small <span style="font-family:Consolas; font-size:x-small <font face="Consolas" size="2" style="font-family:Consolas; font-size:x-small
cn =
</font>
<span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small New<span style="font-family:Consolas; font-size:x-small <span style="font-family:Consolas; font-size:x-small
ADODB.<span style="font-family:Consolas; color:#2b91af; font-size:x-small

<span style="font-family:Consolas; color:#2b91af; font-size:x-small
<span style="font-family:Consolas; color:#2b91af; font-size:x-small Connection




<span style="font-family:Consolas; font-size:x-small <span style="font-family:Consolas; font-size:x-small <font face="Consolas" size="2" style="font-family:Consolas; font-size:x-small
rs =
</font>
<span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small New<span style="font-family:Consolas; font-size:x-small <span style="font-family:Consolas; font-size:x-small
ADODB.<span style="font-family:Consolas; color:#2b91af; font-size:x-small

<span style="font-family:Consolas; color:#2b91af; font-size:x-small
<span style="font-family:Consolas; color:#2b91af; font-size:x-small Recordset




<span style="font-family:Consolas; font-size:x-small <span style="font-family:Consolas; font-size:x-small <font face="Consolas" size="2" style="font-family:Consolas; font-size:x-small
cn.ConnectionString =
</font>
<span style="font-family:Consolas; color:#a31515; font-size:x-small <span style="font-family:Consolas; color:#a31515; font-size:x-small <span style="font-family:Consolas; color:#a31515; font-size:x-small "Provider = MSDAORA.1;Data Source="<span style="font-family:Consolas; font-size:x-small <span style="font-family:Consolas; font-size:x-small
& abcd & <span style="font-family:Consolas; color:#a31515; font-size:x-small <span style="font-family:Consolas; color:#a31515; font-size:x-small <span style="font-family:Consolas; color:#a31515; font-size:x-small ";User ID= "<span style="font-family:Consolas; font-size:x-small <span style="font-family:Consolas; font-size:x-small
& sUserID & <span style="font-family:Consolas; color:#a31515; font-size:x-small <span style="font-family:Consolas; color:#a31515; font-size:x-small <span style="font-family:Consolas; color:#a31515; font-size:x-small ";Password= "<span style="font-family:Consolas; font-size:x-small

<span style="font-family:Consolas; font-size:x-small & sPassword
cn.Open()
<font face="Consolas" size="2" style="font-family:Consolas; font-size:x-small
pobparam =
</font>



<span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small New<span style="font-family:Consolas; font-size:x-small <span style="font-family:Consolas; font-size:x-small
ADODB.<span style="font-family:Consolas; color:#2b91af; font-size:x-small

<span style="font-family:Consolas; color:#2b91af; font-size:x-small
<span style="font-family:Consolas; color:#2b91af; font-size:x-small Parameter




<span style="font-family:Consolas; font-size:x-small <span style="font-family:Consolas; font-size:x-small <font face="Consolas" size="2" style="font-family:Consolas; font-size:x-small

</font>
<span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small With<span style="font-family:Consolas; font-size:x-small

<span style="font-family:Consolas; font-size:x-small pobparam<font face="Consolas" size="2" style="font-family:Consolas; font-size:x-small

.Name =
</font>



<span style="font-family:Consolas; color:#a31515; font-size:x-small
<span style="font-family:Consolas; color:#a31515; font-size:x-small
<span style="font-family:Consolas; color:#a31515; font-size:x-small "POBID"




<span style="font-family:Consolas; font-size:x-small <span style="font-family:Consolas; font-size:x-small <font face="Consolas" size="2" style="font-family:Consolas; font-size:x-small
.Direction = ADODB.
</font>
<span style="font-family:Consolas; color:#2b91af; font-size:x-small <span style="font-family:Consolas; color:#2b91af; font-size:x-small <span style="font-family:Consolas; color:#2b91af; font-size:x-small ParameterDirectionEnum<span style="font-family:Consolas; font-size:x-small

<span style="font-family:Consolas; font-size:x-small .adParamInput<font face="Consolas" size="2" style="font-family:Consolas; font-size:x-small

.Type = ADODB.
</font>



<span style="font-family:Consolas; color:#2b91af; font-size:x-small <span style="font-family:Consolas; color:#2b91af; font-size:x-small <span style="font-family:Consolas; color:#2b91af; font-size:x-small DataTypeEnum<span style="font-family:Consolas; font-size:x-small

<span style="font-family:Consolas; font-size:x-small .adVarChar
.Size = 20
.Value = cboColour.Text
<font face="Consolas" size="2" style="font-family:Consolas; font-size:x-small

</font>



<span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small End<span style="font-family:Consolas; font-size:x-small <span style="font-family:Consolas; font-size:x-small
<span style="font-family:Consolas; color:#0000ff; font-size:x-small
<span style="font-family:Consolas; color:#0000ff; font-size:x-small
<span style="font-family:Consolas; color:#0000ff; font-size:x-small With




<span style="font-family:Consolas; font-size:x-small <span style="font-family:Consolas; font-size:x-small <font face="Consolas" size="2" style="font-family:Consolas; font-size:x-small
rs.Open(
</font>
<span style="font-family:Consolas; color:#a31515; font-size:x-small <span style="font-family:Consolas; color:#a31515; font-size:x-small <span style="font-family:Consolas; color:#a31515; font-size:x-small "select * from Colours where colour = :POBID"<span style="font-family:Consolas; font-size:x-small <span style="font-family:Consolas; font-size:x-small ,
cn, ADODB.<span style="font-family:Consolas; color:#2b91af; font-size:x-small <span style="font-family:Consolas; color:#2b91af; font-size:x-small <span style="font-family:Consolas; color:#2b91af; font-size:x-small CursorTypeEnum<span style="font-family:Consolas; font-size:x-small <span style="font-family:Consolas; font-size:x-small .adOpenForwardOnly,
ADODB.<span style="font-family:Consolas; color:#2b91af; font-size:x-small <span style="font-family:Consolas; color:#2b91af; font-size:x-small <span style="font-family:Consolas; color:#2b91af; font-size:x-small LockTypeEnum<span style="font-family:Consolas; font-size:x-small <span style="font-family:Consolas; font-size:x-small .adLockReadOnly)
<span style="font-family:Consolas; font-size:x-small <span style="font-family:Consolas; font-size:x-small <span style="font-family:Consolas; font-size:x-small <span style="font-family:Consolas; font-size:x-small ...Process recordset and close recordset
<span style="font-family:Consolas; font-size:x-small
<span style="font-family:Consolas <span style="font-size:x-small I would appreciate any help provided - This is a large project with all calls to Oracle written in the manner above (Without the ADODB.Parameter) but I need to get the shared memory usage
down as simply as possible, as it is causing problems.
<span style="font-family:Consolas

View the full article
 

Similar threads

S
Best approach to find duplicate employee from List<T> using LINQ
Replies
0
Views
85
Sudip_inn
S
M
how to embed font when export SSRS report file to pdf using reportviewer in c#
Replies
0
Views
124
motheroftwo
M
M
Insert Value Textbox to Listview Than Insert Them in SQL Server And Retrieve From SQL
Replies
0
Views
76
muhammadanzar
M
K
gibberish text output in word output when generated using the template (.dotx) file
Replies
0
Views
126
KrunalC
K
M
C# WPF How to bind a nested class to nested datagrid in “Datagrid Row-Details”?
Replies
0
Views
98
Mmkottari
M
Back
Top