Newbie question 1

[IonelBurtan]

I am coming from MSSQL (3 years)
Now I have to work with Oracle. I just learn the basics/

I am intereseting in a few Q&A on Oracles stored procedures(probably silly questions):
- how can I make a procedure that returns a recordset?
(If I just simply put a select * from XXX in a proceudre it says it expects an INTO from me)
- does Oracle suports returning more than oen receordset from a SP.
- What is the simplest way I can test a recordset returned from Oracle in VB with ADO

Any help apreciated,

s-)

Blessed is he who in the name of justice and goodwill, sheperds the weak through the valley of darkness...

http://www20.brinkster.com/ionelb

 

[sem]

create procedure getRecordsets(pEmp out sys_refcursor
                               ,pDept out sys_refcursor)
is
begin
  open pEmp for select * from emp;
  open pDept for select * from dept;
end;

Regards, Dima

http://seminihin.narod.ru

 

[IonelBurtan]

Thank you. The fist two questions are answered.
How about the third one?
I have succeded in returning multiple recordsets from Oracle. but I cannot read them in ADO.
The method NextRecordset of ADODB.Recordset raises an error like that:

"Object or provider is not capable of performing requested operation."

So, if I am returning multiple recordsets - how can I read them. Otherwise - there is no use of point 1 and 2 for my application.

Thanks,

s-)

Blessed is he who in the name of justice and goodwill, sheperds the weak through the valley of darkness...

http://www20.brinkster.com/ionelb