View previous topic :: View next topic
|
Author |
Message |
suzeet
New User
Joined: 16 May 2005 Posts: 54
|
|
|
|
I have a program A and calling another program B. Now in the program A the cursor is C1. The cursor is declared in program A.
Now I want to open and fetch the cursor in program B. Is it possible? If not why? If yes why and how? |
|
Back to top |
|
|
suzeet
New User
Joined: 16 May 2005 Posts: 54
|
|
|
|
I have a calling program and a called program. Both are bound to same plan but different collection. Now in the program how do you call the called program. |
|
Back to top |
|
|
itssreehere Warnings : 1 New User
Joined: 10 Jan 2006 Posts: 65 Location: chennai
|
|
|
|
#2) using plan/packege doesn't make any difference in application program. It will be a normal call only. That's my understanding.Please correct me if i'm wrong |
|
Back to top |
|
|
itssreehere Warnings : 1 New User
Joined: 10 Jan 2006 Posts: 65 Location: chennai
|
|
|
|
#1) Yess you can do that. You can declare in one program and open in another program if you delare cursor as a global cusor. u need syntax??
DECLARE <Cursor_Name> CURSOR
[LOCAL | GLOBAL]
[READ_ONLY | SCROLL_LOCKS | OPTIMISTIC]
FOR <Selecting Statements>
[FOR UPDATE [OF Column_name[,....N]]] |
|
Back to top |
|
|
|