We've been converting some stored procedures in SQL Server to Oracle
which are called from VB using ODBC. One of these procedures is a
simple select statement like:
create procedure xxx _at_varin as
select * from table1
where a = _at_varin
go
In VB, calling this proc with a createsnapshot returns a recordset i.e.
set snp = db.createsnapshot("xxx " & val1, DB_SQLPASSTHROUGH)
This doesn't seem possible using Oracle procedures! Has anyone else come
across a similar problem?
Any help would be appreciated.
Regards
Chun.