Missed obvious reply in line :(
--
Niall Litchfield
Oracle DBA
Audit Commission UK
http://www.niall.litchfield.dial.pipex.com/
"Tim Dale" <dev_at_cavendish.co.uk> wrote in message
news:7819e11a.0404270646.22cfdbf0_at_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?
Received on Tue Apr 27 2004 - 11:04:49 CDT
