| passing recorset as a parameter [message #197133] |
Tue, 10 October 2006 03:43  |
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 #197159 is a reply to message #197150] |
Tue, 10 October 2006 05:20  |
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 |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
