Re: dbms_standard

A copy of this was sent to "zonnet" <cpwets_at_zonnet.nl> (if that email address didn't require changing) On Fri, 3 Dec 1999 22:02:31 +0100, you wrote:

>
>Question,
>
>when I want to use the put_line function in de package dbms_output,
>my code would be like this:
>
> dbms_output.put_line ('testing');
>
>When I want to use a function or procedure in the dbms_standard package
>the name of the package I can leave away, so my code would be like this:
>
>raise_application_error (....)
>
>and not
>
>dbms_standard.raise_application_error(....)
>

standard (not dbms_standard) is just 'special' that way. you don't need to qualify it with anything to get at the functions.

all other packaged procedures/functions must be qualified by the package name. you can create a synonym for the package (in fact, a synonym dbms_output already exists in your database for sys.dbms_output). You cannot create a synonym to a packaged procedure/function -- only to the package.

>
>Can anybody tell me this???? I can't find a synomym either.
>
>greeting Dennis Wets
>
>

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Sat Dec 04 1999 - 08:10:30 CST