ASP calling a DLL which calls an Oracle Stored Procedure r..

Well, the subject line sums it nicely. Hello all, using Windows2000,
9i(9.0.2?), OraOLEDB driver by Oracle.

I have an Oracle stored procedure that is called by a DLL which is
called from an ASP page. Everything functions correctly when I use the
DLL in a test application I wrote with VB. When I try to do this from
an ASP page only the input parameters 'work'. The output params never
return anything or maybe, more correctly, the params for the DLL call
never get assigned a value. The signature of the stored procedure is
....

CREATE OR REPLACE PROCEDURE checkOutFile( pProjName IN VARCHAR2,
pFileName IN VARCHAR2, pUser IN VARCHAR2, pVer IN NUMBER DEFAULT 0,
pOutComm IN VARCHAR2 DEFAULT NULL, pFcontent OUT CLOB, pSQLcode OUT
VARCHAR2, pSQLmsg OUT VARCHAR2 )

The ASP code is ...

<%
prjMan.checkoutfile CStr(pName), CStr(FName), CSt(FUser), CInt(FVer),
CStr(chkOutComm), CStr(retResult), CStr(retSqlCode), CStr(retSqlMsg)

Response.Write( "retResult: " & retResult & "<br>" & "retSqlCode: " &
retSqlCode & "<br>" & "retSqlMsg: " & retSqlMsg & "<br>" )
%>

Note, the DLL method that calls the Oracle SP share the same name,
sorry if that is screwy.
Thanks in advance for your help.
Mike

Okay, problem solved. I don't know if this is a kludge or not, if you
would like to tell me I'd be happy to listen.

Originally, the DLL was designed to be used by an app with specific
types. ASP uses variants and you cannot explicitly create its
subtypes (int, string,...) so I was trying to use the conversion
functions. This never did look right and it wasn't because I believe
this was essentially turning my byRef return params into byVal's (just
my way of describing what I am not sure of . So, I wrapped the
original methods with 'web' methods that use variant parameters and do
the conversions there. Feel free to correct me, I would like to hear
other ideas.

Thanks,
Mike


mndarius.RemoveThis@butlermfg.com (mndarius) wrote in message news:<f8d3fefc.0401191435.6bbeb4fb.RemoveThis@posting.google.com>...
 > Well, the subject line sums it nicely. Hello all, using Windows2000,
 > 9i(9.0.2?), OraOLEDB driver by Oracle.
 >
 > I have an Oracle stored procedure that is called by a DLL which is
 > called from an ASP page. Everything functions correctly when I use the
 > DLL in a test application I wrote with VB. When I try to do this from
 > an ASP page only the input parameters 'work'. The output params never
 > return anything or maybe, more correctly, the params for the DLL call
 > never get assigned a value. The signature of the stored procedure is
 > ...
 >
 > CREATE OR REPLACE PROCEDURE checkOutFile( pProjName IN VARCHAR2,
 > pFileName IN VARCHAR2, pUser IN VARCHAR2, pVer IN NUMBER DEFAULT 0,
 > pOutComm IN VARCHAR2 DEFAULT NULL, pFcontent OUT CLOB, pSQLcode OUT
 > VARCHAR2, pSQLmsg OUT VARCHAR2 )
 >
 > The ASP code is ...
 >
 > <%
 > prjMan.checkoutfile CStr(pName), CStr(FName), CSt(FUser), CInt(FVer),
 > CStr(chkOutComm), CStr(retResult), CStr(retSqlCode), CStr(retSqlMsg)
 >
 > Response.Write( "retResult: " & retResult & "<br>" & "retSqlCode: " &
 > retSqlCode & "<br>" & "retSqlMsg: " & retSqlMsg & "<br>" )
 > %>
 >
 > Note, the DLL method that calls the Oracle SP share the same name,
 > sorry if that is screwy.
 > Thanks in advance for your help.
 > Mike<!-- ~MESSAGE_AFTER~ -->