Newbie's question

From: Kenneth Xu <xu_dong_at_NOSPAM.irel.com.sg>
Date: Wed, 2 Sep 1998 10:19:31 +0800
Message-ID: <35ecad26.0@news.cyberway.com.sg>

Hi all,

I just started to use VB6 ADO against Oracle8 database server, and hope somebody can point me a direction on how to use the Oracle stored procedure in VB, i.e. how to call, pass parameter, return result and etc.

Another question: To generate AutoNumber in Oracle, we used Oracle sequence and before insert trigger. So to get the current generated AutoNumber, we use an immediately sequence CURRVAL select from Oracle in VB code. That works, but it seems only work with Oracle, and makes my code totally Oracle depended. I want to know if there is a better way?

Thank you,

Ken Received on Tue Sep 01 1998 - 21:19:31 CDT