Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Calling Oracle 8i stored procedures from VB

Calling Oracle 8i stored procedures from VB

From: Spotly <spotly_at_aol.comEatSpam>
Date: 02 Feb 2000 02:37:39 GMT
Message-ID: <20000201213739.25801.00001017@ng-fn1.aol.com>


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 = cn

.CommandText = RptQRY
.CommandType = adCmdText
.Parameters.Append .CreateParameter(, adVarChar, adParamInput)
  End With
  RptCmd(0) = cmbMonth.Text

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US