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 -> Re: Is it possible using stored procedure like this way???

Re: Is it possible using stored procedure like this way???

From: tojo <Tojo_at_hotmail.com>
Date: Wed, 4 Aug 2004 08:42:03 +0200
Message-ID: <MPG.1b7aa3a9927e6db59896f9@news.t-online.de>


In article <ceogn2$a9u$1_at_sunnews.cern.ch>, dominique_hung_at_hotmail.com says...
> Hi there,
>
> I create a package Pkg which contents one procedure ProX(paramIn) and
> one function FunY(paramIn). The ProX will get a value by calling FunY.
> In fact the FunY will insert "paramIn" into table and return an Id.
> Normally, with PL/SQL, this Id will show on the screen.
> If I use following syntax in ASP:
>
> objCmd.CommandText = "{call Pkg.ProX(?)}"
>
> I always get error message:
> Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
> [Microsoft][ODBC driver for Oracle][Oracle]ORA-20004:...
>
>
> Coule someone tell me why?

Are you binding the parameter correctly? It would help if you posted the complete error message and your code.

Received on Wed Aug 04 2004 - 01:42:03 CDT

Original text of this message

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