Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Calling Oracle 8i stored procedures from VB
I've been trying to resolve this on the vb newsgroup but no luck so I'll try
here.
I know it is a VB problem, but on the off chance that some of you all might be
familiar with this ...
1.
I'm using the following code, but it chokes on the varchar parameter. The value
that I'm trying to assign to the input parameter is a string - "2000"
In a seperate function I can get similar code to work when the input parameter
is an integer. cn is my connecton object and is opened with the following
connection string:
"Provider=MSDAORA;Data Source=myserver;User
ID=myid;Password=mypassword;"
Here's the call to the stored procedure:
RptQRY = "{call Pkg_Reports.Report_New_Cust(?,{resultset 9,Lst_Name," _
& "Fst_Name,Adrs,Ctty,Stt,Zpcd,Phn,Dtte,Dtte})}"
Set RptCmd = New ADODB.Command
With RptCmd
Set .ActiveConnection = cnEnd With
.CommandText = RptQRY
.CommandType = adCmdText
.Parameters.Append .CreateParameter(, adVarChar, adParamInput)
2. I'm still learning about ODBC and such, but I need to find a driver and an example of a connection string that will allow me to design and save diagrams to the server. I can connect and create the diagrams, but when I go to save them I get an error message that says the driver doesnt support that.
Any help would be appreciated. Tim Hanson Received on Tue Feb 01 2000 - 20:37:39 CST
![]() |
![]() |