Re: Problem with IN parameters to an Oracle stored procedure

On Nov 6, 6:43 am, swetha <swethasiva...@xxxxxxxxx> wrote:
Hello all

I had earlier posted the same problem I am having on
comp.java.lang.programmer earlier and someone suggested this post
would probably fall better under this group. Here is the link to the
original post with the original post copy pasted below.

http://groups.google.co.in/group/comp.lang.java.programmer/browse_thr...

Since then I have changed the IN parameter to my stored procedure to
read as

clID IN TABLEA.CLIENTID%TYPE

instead of clientID, based on a suggestion to the earlier post and
have still had no luck.

Any suggestions are welcome.

Thanks
Swetha

what happens if you change the procedure definition to have all
the parameters defined as NUMBER, or NUMBER (20,0)?
Joe Weinstein at BEA Systems

.

Relevant Pages

  • Re: SQL Send Adapter
    ... I am trying to use this suggestion without success so far. ... Set the field for the XML part of the SQL insert message to distinguished. ... I am clear on how to create the schema and the ports; ... on how to pass the input XML message to the stored procedure. ...
    (microsoft.public.biztalk.general)
  • Re: Inserting large amounts of text using ntext or text
    ... > Have you run your stored procedure in Query Analyzer with sample data? ... I have tried this with both text and ntext datatypes, ... >> @Details ntext, ... >> suggestion or tip? ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: XML from SQL
    ... xr is the XMLReader containing the results of the stored procedure. ... Also note that that suggestion is only possible if you use the FOR XML ROOT instruction to ensure SQL server outputs a root element. ...
    (microsoft.public.sqlserver.xml)
  • Inserting large amounts of text using ntext or text
    ... the stored procedure commits and most of the desired results ... Dim conConnection As New ... I have modified the portion of the code that declares the "@Details" ... suggestion or tip? ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Color a single digit in a mult-digit number cell
    ... Nick Hodge wrote: ... > I couldn't understand the original post unfortunately, ... >>> Suggestion for Microsoft ...
    (microsoft.public.excel.misc)