Re: [Q] create procedure gone on 10G?????

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Wed, 12 Jan 2005 23:25:31 -0800
Message-ID: <41e62284$1_1@127.0.0.1>

aaa wrote:

> I saw a person post on newsgroup said:
>
>

>>From 10g docs
>>"The following CREATE statements are obfuscated:
>>
>>CREATE [OR REPLACE] FUNCTION function_name
>>CREATE [OR REPLACE] PROCEDURE procedure_name
>>CREATE [OR REPLACE] PACKAGE package_name
>>CREATE [OR REPLACE] PACKAGE BODY package_name
>>CREATE [OR REPLACE] TYPE type_name AS OBJECT
>>CREATE [OR REPLACE] TYPE type_name UNDER type_name
>>CREATE [OR REPLACE] TYPE BODY type_name

>
>
>
> Can anyone prove it or just rumor?
>
> Thanks.

CREATE OR REPLACE PROCEDURE test IS
BEGIN
   NULL;
END test;
/

wrap iname=c:\temp\warptest

CREATE OR REPLACE PROCEDURE test wrapped a000000
b2
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
7
2a 5d
N9Dfr3eEaES1h2uLDCg9ZyIXfaIwg5nnm7+fMr2ywFznUrLLzKV0i8DAMv7ShglppZmBCC2L wIHH+9lUgqamHseeUg==

/

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Thu Jan 13 2005 - 01:25:31 CST