Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SP call using ADO command object

Status
Not open for further replies.
sravva

sravva

Programmer
May 4, 2004
10
US
I am calling a oracle stored procedure having one of column as "PL/SQL TABLE" through Visual basic code using ADO objects. I am getting wrong types passed error.
at the following code:
cmd.Parameters.Append cmd.CreateParameter("P_REPORT_CD", adVarchar, adParamInput, Len(sReportCd(0)), sReportCd(0)).

Please help me!!!
 
Status
Not open for further replies.

Similar threads

Livia8
  • Locked
  • Question
Alternative to "locate" command
Replies
0
Views
335
Livia8
Livia8
Olutee360
  • Locked
  • Question
Group by using values in a range 1
Replies
4
Views
131
Olutee360
Olutee360
EM1107
  • Locked
  • Question
Insert date and time using UTC time in a DATE column
Replies
14
Views
609
EM1107
EM1107
kernal
  • Locked
  • Question
Extract string before the first "-" it finds and the space prior to the "-"
Replies
5
Views
126
carp
carp
ClowneUser
  • Locked
  • Question
Using sysdate as a paramter
Replies
1
Views
103
Beilstwh
Beilstwh

Part and Inventory Search

Sponsor

Back
Top