Oracle database queries

[anju123]

Hi Friends, I have few queries related to Oracle database. Can anyone help me out?
1. How can we interact with two sessions in oracle database?
2. Can we pass array as a parameter in procedure and also can we pass cursor as a parameter in procedure? how?
3. Is it possible to lock row/rows in a form in your own session? how?

Thanks in advance.
Anju

 

[sem]

1. Use (in order of complexity starting from easiest) DBMS_ALERT or DBMS_PIPE or DBMS_AQ packages.
2. Yes. But the variable datatype sholud be PUBLIC, i.e. either declared in some package spec or created within database.
3. Issue LOCK TABLE or SELECT..FOR UPDATE. Though if you run your form against Oracle, you don't need explicit locking at all.

Regards, Dima

 

[anju123]

Thanks Dima, for the reply.

Anju