Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Is it possible using stored procedure like this way???
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.
![]() |
![]() |