Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-11-08 : 23:29:46
|
Cai writes "Hi, thanks for providing a place for me to submit questions.
I have converted dozens of SQL Server stored procedures into Oracle procedures. As in SQL Server, we use ODBC to connect the Oracle database. The problem is that I don't know how to call those procedures in Oracle. One of the procedure is the following:
++++++++++++++++++++++++++++++++++++++++++++++++++++++++
PROCEDURE "HOST_LIST" (HostCode in varchar2, iRetval out number)
is
begin
select count(Host_Code) into iRetval
from tdirectory_host
where Host_Code = HostCode;
end;
+++++++++++++++++++++++++++++++++++++++++++++++++++++++
The ASP code is connected to Oracle successfully, but I don't know how to run the procedure, such as how to feed the procedure and get a returned value back.
I appreciate it very very much if you can provide me an answer or send me some sample code.
Thanks again.
Best Regards,
Cai" |
|
|
|
|
|
Oracle SQL ---- URGENT HELP IS NEEDED!!!