Home » SQL & PL/SQL » SQL & PL/SQL » passing recorset as a parameter
passing recorset as a parameter [message #197133] Tue, 10 October 2006 03:43 Go to next message
sujeethbala
Messages: 25
Registered: October 2006
Location: INDIA
Junior Member
hi
i want to know can we pass recordset as a parameter from visual basic to oracle procedure, and in procedure using cursor can we use those records.

thanks
Re: passing recorset as a parameter [message #197150 is a reply to message #197133] Tue, 10 October 2006 05:00 Go to previous messageGo to next message
dmitry.nikiforov
Messages: 723
Registered: March 2005
Senior Member
Does anything force you to pass recordset from VB to Oracle instead of opening cursor inside the procedure itself ?
It's much more easy and transparent way.

Rgds.
Re: passing recorset as a parameter [message #197159 is a reply to message #197150] Tue, 10 October 2006 05:20 Go to previous messageGo to next message
sujeethbala
Messages: 25
Registered: October 2006
Location: INDIA
Junior Member
dmitry.nikiforov wrote on Tue, 10 October 2006 15:30

Does anything force you to pass recordset from VB to Oracle instead of opening cursor inside the procedure itself ?
It's much more easy and transparent way.

Rgds.


hi
i have some records in my recorset. i want to insert all these records into a table. before inserting i have to perform some calculation which i want to do it in server. if i can pass this recordset then in oracle procedure i can do all these things and insert it finally.
if u have any other ways to do this please let me know.
Re: passing recorset as a parameter [message #197167 is a reply to message #197159] Tue, 10 October 2006 05:51 Go to previous message
dmitry.nikiforov
Messages: 723
Registered: March 2005
Senior Member
And why can't you do everything in server ?

SQL> declare
  2   cnt number;
  3   id number := 441132394629;
  4  begin
  5   --Calculations
  6   select count(*) into cnt from calls where cli = id;
  7   --Insertion
  8   insert into calls2 select * from calls where cli = id;
  9  end;
 10  /

PL/SQL procedure successfully completed.


Rgds.
Previous Topic: Questions on nested select statements
Next Topic: How do i know the tablespace is using the current user?
Goto Forum:
  


Current Time: Sun Dec 04 00:22:49 CST 2016

Total time taken to generate the page: 0.25984 seconds