Hi folks, hope you can help.
Using ADO component to connect to Oracle via ODBC
I have no problems issuing select/insert commands in the .asp file and
know how to work through the recordset that is returned BUT now I want
to invoke stored Oracle procedures and functions. If I change the sql
string that I have to
"execute <procedure_name>", or "select <function_name>" then I get an
error to the effect that the execute statement is illegal or the
table/view does not exist. There is no such table/view, I know, but a
valid function_name exists and I can use that from SQL*Plus command
line. Also, if I had a function that returned an integer as opposed to
a recordset, could I just 'catch' it in a normal variable or do I have
to use a recordset object?
Thanks for reading this.