Home » SQL & PL/SQL » SQL & PL/SQL » Name referencing using SYNONYMS
Name referencing using SYNONYMS [message #2891] Tue, 20 August 2002 00:41 Go to next message
Mark Grimshaw
Messages: 73
Registered: June 2002
Member
Hello,

I am writing some packages of stored procedures and want to refer to a cursor ref type that I have defined in one package from within another package without using the prefix package name. For example if I have a package defined like this:-

CREATE PACKAGE MyPackage AS
...
...
TYPE MyCursor IS REF CURSOR;
...
END;

I want to refer to this cusror in another package:-

CREATE PACKAGE AnotherPackage AS

PROCEDURE DoSomething(aCursor MyCursor);

END;

How do I do this - presumably with Synonyms but I can't seem to get it to work with public synonyms.

Thanks
Re: Name referencing using SYNONYMS [message #2902 is a reply to message #2891] Tue, 20 August 2002 09:35 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
Mark, you won't be able to avoid the prefix here. You could create a synonym for the package, but you would then still have to use the synonym name as the prefix.
Previous Topic: DATE FUNCTION
Next Topic: temperal data
Goto Forum:
  


Current Time: Fri Apr 26 07:33:34 CDT 2024