Hi!
I was using this way for parameters IN and to return only one value with a
function:
set nCodStatus [ns_ora exec_plsql $db "begin :1 := ste.doTrx( $nIDCliente,
'$txtTipoTar', '$txtNroTarj', '$txtCodSeg', '$txtMeses', '$txtAnios',
$nTotal, '01'); end;" ]
and this
ns_db dml $db "begin doSetFechaPagado('$txtSessionID'); end;"
where "ste" is an Oracle Package and "doSetFechaPagado" is an Oracle
procedure.
The only problem was that I can't return a value in an OUT parameter.
Regards.
Ariel.
----- Original Message -----
From: "Lane Wimberley" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, October 24, 2001 3:18 PM
Subject: [AOLSERVER] Returning complex data from Oracle stored procedure...?
> Hello, AolServants! Is it possible to bind the value returned
> by an Oracle stored procedure (either return of a function, or
> an IN OUT parameter of a procedure) to a Tcl variable in the
> AolServer environment. In particular, I'm wondering about complex
> data types, like records, arrays, tables or even cursors. By "bind
> to a variable," I really only mean "gain access to the return value
> in Tcl;" it needn't be bound to a particular variable that I specify.
>
> I would like to be able to encapsulate a query, say, in a stored
> procedure, and then make the results of the query available to
> ADPs and the like. I would like to do this as an alternative to
> the more conventional practice of posing the literal query directly
> from the ADP.
>
> Help...?
>
> Thanks!
>
> Lane Wimberley
> Wayport, Inc.
> Austin, TX
