Returning a value from Oracle via OLEDB (in ASP)

Returning a value from Oracle via OLEDB (in ASP)

am 10.01.2008 18:51:17 von CJM

Bit of a noob question I'm afraid... I've had a look on t'interweb and it
has got me so far, but I'm doing something wrong.

I've managed to run procedures with an output parameter, but a return value
from a function is sufficiently different to stump me.

Set oParam = .CreateParameter("iSequenceNo", adInteger, adParamReturnValue)
..Parameters.Append oParam

Set oParam = .CreateParameter("sSerialNo", adVarchar, adParamInput, 50,
sSerialNo)
..Parameters.Append oParam

Set oParam = .CreateParameter("sPartNo", adVarchar, adParamInput, 50,
sPartNo)
..Parameters.Append oParam

..CommandText= "{? = Call
IFSAPP.Part_Serial_History_API.Get_Latest_Sequence_No(?, ?)}"
..Execute()

..Parameters.Delete "sSerialNo"
..Parameters.Delete "sPartNo"

I understand in this scenario that the Return Value must be the first
parameter supplied.
When I run my code, it completes without any errors, but iSequenceNo is not
populated. I assume the problem is the way in which I am calling the
function, but I'm not sure what exactly is wrong.

Any help would be appreciated.

Thanks

Chris

Re: Returning a value from Oracle via OLEDB (in ASP)

am 16.01.2008 00:50:20 von CJM

nations of the earth; that as they have offended Him by
worshipping gods who were not their God, so He will provoke them by calling
a people who are not His people; that He desires that all His words be
preserved for ever, and that His book be placed in the Ark of the Covenant
to serve for ever as a witness against them.

Isaiah says the same thing, 30.

632. On Esdras.--The story that the books were burnt with the temple proved
false by Maccabees: "Jeremiah gave them the law."

The story that he recited the whole by heart. Josephus and Esdras point out
that he read the book. Baronius, Annales Ecclesiastici a Christo Nato ad
Annum 1198, 180: Nullus penitus Hebraeorum antiquorum reperitur qui
tradiderit libros periisse et per Esdram esse restitutos, nisi in IV Esdrae.

The story that he changed the letters.

Philo, in Vita Mosis: Illa lingua ac character quo antiquitus scripta est
lex sic permansit usque ad LXX.

Josephus says that the Law was in Hebrew when it was translated by the
Seventy.

Under Antiochus and Vespasian, when they wanted to abolish the books, and
when there was no prophet, they could not do so. And under the Babylonians,
when no perse