| Re: Cursor over two schemas? [message #369798] |
Fri, 13 October 2000 05:29 |
Prem
Messages: 79
Registered: August 1998
|
Member |
|
|
Fabian,
If i got your question right, you have two schemas SIV which contains HERST_ADR and MEDIA which contains M_HERST_ADR table. Now you created a procedure in SIV. This procedure is not able to see M_HERST_ADDR which is in MEDIA.
If thats the case, you'll have to create a synonym in SIV (where the procedure resides) based on the M_HERST_ADDR.
connect to MEDIA schema.
Grant INSERT, UPDATE, DELETE, SELECT ON M_HERST_ADDR TO SIV;
Connect to SIV
Create Synonym M_HERST_ADDR For MEDIA.M_HERST_ADDR;
you dont have to change any code in your procedure. Just to verify, from SIV schema, if you issue a SELECT * FROM M_HERST_ADDR, it should show the records. Now try executing the procedure to verify from SIV user.
hth
Prem :)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
