beginner question

From: <bravo6500_at_my-deja.com>
Date: Fri, 11 Jun 1999 16:08:21 GMT
Message-ID: <7jrc9c$jj9$1@nnrp1.deja.com>

Hi, I am trying to compile a package that has a cursor which references tables in another schema. I keep getting the compilation error (SATURN.tablename needs to be declared.) However, when I run the select statement from the cursor in a regular sql edit window, I get my desired results. Does this have to do with public synonyms? I'm new to development so apologies if this is a 'stupid' question. Any help or advice would be much appreciated.

Thanks,
MM

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Jun 11 1999 - 11:08:21 CDT