Re: Sending CLOBs to Oracle using VB/ADO

From: Niall Litchfield (n-litchfield_at_audit-commission.gov.uk)
Date: 04/27/04 

Date: Tue, 27 Apr 2004 17:04:49 +0100

Missed obvious reply in line :( 

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK
http://www.niall.litchfield.dial.pipex.com/
"Tim Dale" <dev@cavendish.co.uk> wrote in message
news:7819e11a.0404270646.22cfdbf0@posting.google.com...
> Can anyone help ?
<snip>
> Only, it isn't working.  Oracle keeps returning the error :
> ORA-06550: line 1, column 7:
> PLS-00306: wrong number or types of arguments
>
> (If I remove the parameter from the stored procedure and the call to
> it, it
> all works fine.  i.e. the other parameters are all correct.)
<snip>
> The SP definition is as follows :
>
>   PROCEDURE main (p_afp_clob        IN  CLOB
<snip>
> and my VB code, which uses a wrapper functions, looks like :
>         Call oDbase.bAddProcTag("p_afp_clob", sXML, adLongVarChar)
<snip>
> The wrapper function bAddProcTag() sets the direction (defaulted to
> adParamInput),
> name, size and value of the parameter, and then appends the parameter
> to the ADO
> parameters collection.
That sounds like you are setting p_afp_clob to be an input parameter, when
the spec says that it should be an output parameter?