RE: Dropping & re-Creating Sequences in PL/SQL

--0__=bU5NJyyNEDdF3Sc8XgsAqtaPP1NkyBeF4yPpvU3LjoIbL4r48IeCJNVD Content-type: text/plain; charset=us-ascii Content-Disposition: inline

I have a stupid method myself to "reset" the sequence to a lower value.

But if you have a better way to "reset" the value.. then do let me know! :)

Winnie

eg:

13:52:54 WLIU( @sj) > create sequence test_seq
13:53:00   2  start with 1000
13:53:04   3  increment by 1;

Sequence created.

13:53:42 WLIU( @sj) > select test_seq.nextval from dual;

  NEXTVAL

     1000

1 row selected.

13:54:03 WLIU( @sj) > select test_seq.nextval from dual;

  NEXTVAL

     1001

1 row selected.

13:54:33 WLIU( @sj) > alter sequence test_seq 13:54:43 2 increment by -900;

Sequence altered.

13:54:51 WLIU( @sj) > select test_seq.nextval from dual;

  NEXTVAL

      101

1 row selected.

13:55:00 WLIU( @sj) > alter sequence test_seq 13:55:09 2 increment by 1;

Sequence altered.

13:55:13 WLIU( @sj) > select test_seq.nextval from dual;

  NEXTVAL

      102

1 row selected.

13:55:21 WLIU( @sj) >

Alex Hillman <alex_hillman_at_physia.com> on 07/03/2000 02:35:41 PM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Winnie Liu/HQ/ISC)

Subject: RE: Dropping & re-Creating Sequences in PL/SQL

How would you reset the sequence? From Oracle 8i SQL reference "to restart the sequence from the different number you must drop and recreate the sequence".

Alex Hillman

-----Original Message-----
Sent: Thursday, June 29, 2000 2:09 PM
To: Multiple recipients of list ORACLE-L

I'll take it a step further and ask 'Why are you dropping the sequence?'

Just reset it to the value you need.

Jared

On Wed, 28 Jun 2000, Larry G. Elkins wrote:

> While DDL statements aren't directly supported in PL/SQL, since the
person
> is on 8.1.6 (8i Release 2), there isn't (normally) a need to use DBMS_SQL
in
> this case. Dynamic SQL is still needed, but, the old DBMS_SQL construct
is
> not. The "execute immediate", as the person spoke of, sounds like it
should
> work just fine. There are still cases where the old DBMS_SQL stuff is
> preferable; but, creating and dropping sequences should be able to be
done
> with "execute immediate" without resorting to DBMS_SQL:
>
> SQL> begin
> 2 execute immediate 'create sequence xxx';
> 3 end;
> 4 /
>
> PL/SQL procedure successfully completed.
>
> SQL> select xxx.nextval from dual;
>
> NEXTVAL
> ----------
> 1
>
> SQL> begin
> 2 execute immediate 'drop sequence xxx';
> 3 end;
> 4 /
>
> PL/SQL procedure successfully completed.
>
> SQL> select xxx.nextval from dual;
> select xxx.nextval from dual
> *
> ERROR at line 1:
> ORA-02289: sequence does not exist
>
> So, what type of errors are you seeing? When you use the execute
immediate
> with the sequence stuff in-line, you say it doesn't compile. When you
assign
> the command to a variable, then, reference the variable in your execute
> immdediate, you say it compiles. Does it work then?
>
> I bring this up because I can do what you are trying do. This is on an NT
> workstation with SP5. And using the newer dynamic SQL approach of execute
> immediate like you did.
>
> There could be other things in play here (permissions and roles versus a
> direct priv thing, maybe bugs). I have no idea. I have no problem doing
what
> you want to do.
>
> Regards,
>
> Larry G. Elkins
> The Elkins Organization Inc.
> elkinsl_at_flash.net
> 214.954.1781
>
> -----Original Message-----
> Turner
> Sent: Wednesday, June 28, 2000 10:25 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Since those particular statements are considered DDL statements, you need
> to use the DBMS_SQL commands to execute them within a pl/sql package.
>
> Christine Turner
> Database Administrator
> IPS-Sendero
> Scottsdale, Arizona
> Phone: (800) 321-6899 ext. 3286
> Fax: (480) 946-8224
> E-mail: christine.turner_at_ips-sendero.com
>
>
>
> -----Original Message-----
> From: Mike & Martha [SMTP:mmrose_at_home.com]
> Sent: Wednesday, June 28, 2000 7:09 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Dropping & re-Creating Sequences in PL/SQL
>
>
> Hello,
>
> I've been unable to get the following commands to 'compile' in a PL/SQL
> package body in Oracle 8.1.6 Version 2 (8i with NTS 4.0 SP 6a):
>
> DROP SEQUENCE sequence_name;
>
> CREATE SEQUENCE sequence_name;
>
> I get errors like the commands aren't recognized.
>
> When I try to use EXECUTE IMMEDIATE 'DROP SEQUENCE sequence_name'
>
> I still get compile errors.
>
> I can compile when I use to following:
>
> Temp VARCHAR2(60);
>
> Temp := 'DROP SEQUENCE sequence_name';
>
> EXECUTE IMMEDIATE Temp;
>
> I would really appreciate some help here!
>
> Michael Rose
> mmrose_at_home.com
>
> --
> Author: Larry G. Elkins
> INET: elkinsl_at_flash.net
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

Jared Still
Certified Oracle DBA and Part Time Perl Evangelist ;-) Regence BlueCross BlueShield of Oregon
jkstill_at_bcbso.com - Work - preferred address jkstill_at_teleport.com - private

--
Author: Jared Still
  INET: jkstill_at_bcbso.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


--0__=bU5NJyyNEDdF3Sc8XgsAqtaPP1NkyBeF4yPpvU3LjoIbL4r48IeCJNVD
Content-type: text/html; 
	name="att1.htm"
Content-Disposition: attachment; filename="att1.htm"
Content-transfer-encoding: base64
Content-Description: Internet HTML

PCFET0NUWVBFIEhUTUwgUFVCTElDICItLy9XM0MvL0RURCBIVE1MIDMuMi8vRU4iPg0KPEhUTUw+
DQo8SEVBRD4NCjxNRVRBIEhUVFAtRVFVSVY9IkNvbnRlbnQtVHlwZSIgQ09OVEVOVD0idGV4dC9o
dG1sOyBjaGFyc2V0PWlzby04ODU5LTEiPg0KPE1FVEEgTkFNRT0iR2VuZXJhdG9yIiBDT05URU5U
PSJNUyBFeGNoYW5nZSBTZXJ2ZXIgdmVyc2lvbiA1LjUuMjQ0OC4wIj4NCjxUSVRMRT5SRTogRHJv
cHBpbmcgJmFtcDsgcmUtQ3JlYXRpbmcgU2VxdWVuY2VzIGluIFBML1NRTDwvVElUTEU+DQo8L0hF
QUQ+DQo8Qk9EWT4NCg0KPFA+PEZPTlQgU0laRT0yPkhvdyB3b3VsZCB5b3UgcmVzZXQgdGhlIHNl
cXVlbmNlPyBGcm9tIE9yYWNsZSA4aSBTUUwgcmVmZXJlbmNlICZxdW90O3RvIHJlc3RhcnQgdGhl
IHNlcXVlbmNlIGZyb20gdGhlIGRpZmZlcmVudCBudW1iZXIgeW91IG11c3QgZHJvcCBhbmQgcmVj
cmVhdGUgdGhlIHNlcXVlbmNlJnF1b3Q7LjwvRk9OVD48L1A+DQoNCjxQPjxGT05UIFNJWkU9Mj5B
bGV4IEhpbGxtYW48L0ZPTlQ+DQo8L1A+DQoNCjxQPjxGT05UIFNJWkU9Mj4tLS0tLU9yaWdpbmFs
IE1lc3NhZ2UtLS0tLTwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTI+RnJvbTogSmFyZWQgU3RpbGwg
WzxBIEhSRUY9Im1haWx0bzpqa3N0aWxsQGJjYnNvLmNvbSI+bWFpbHRvOmprc3RpbGxAYmNic28u
Y29tPC9BPl08L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yPlNlbnQ6IFRodXJzZGF5LCBKdW5lIDI5
LCAyMDAwIDI6MDkgUE08L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yPlRvOiBNdWx0aXBsZSByZWNp
cGllbnRzIG9mIGxpc3QgT1JBQ0xFLUw8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yPlN1YmplY3Q6
IFJFOiBEcm9wcGluZyAmYW1wOyByZS1DcmVhdGluZyBTZXF1ZW5jZXMgaW4gUEwvU1FMPC9GT05U
Pg0KPC9QPg0KPEJSPg0KPEJSPg0KDQo8UD48Rk9OVCBTSVpFPTI+SSdsbCB0YWtlIGl0IGEgc3Rl
cCBmdXJ0aGVyIGFuZCBhc2sgJ1doeSBhcmUgeW91IGRyb3BwaW5nIHRoZSBzZXF1ZW5jZT8nPC9G
T05UPg0KPC9QPg0KDQo8UD48Rk9OVCBTSVpFPTI+SnVzdCByZXNldCBpdCB0byB0aGUgdmFsdWUg
eW91IG5lZWQuPC9GT05UPg0KPC9QPg0KDQo8UD48Rk9OVCBTSVpFPTI+SmFyZWQ8L0ZPTlQ+DQo8
L1A+DQoNCjxQPjxGT05UIFNJWkU9Mj5PbiBXZWQsIDI4IEp1biAyMDAwLCBMYXJyeSBHLiBFbGtp
bnMgd3JvdGU6PC9GT05UPg0KPC9QPg0KDQo8UD48Rk9OVCBTSVpFPTI+Jmd0OyBXaGlsZSBEREwg
c3RhdGVtZW50cyBhcmVuJ3QgZGlyZWN0bHkgc3VwcG9ydGVkIGluIFBML1NRTCwgc2luY2UgdGhl
IHBlcnNvbjwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTI+Jmd0OyBpcyBvbiA4LjEuNiAoOGkgUmVs
ZWFzZSAyKSwgdGhlcmUgaXNuJ3QgKG5vcm1hbGx5KSBhIG5lZWQgdG8gdXNlIERCTVNfU1FMIGlu
PC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj4mZ3Q7IHRoaXMgY2FzZS4gRHluYW1pYyBTUUwgaXMg
c3RpbGwgbmVlZGVkLCBidXQsIHRoZSBvbGQgREJNU19TUUwgY29uc3RydWN0IGlzPC9GT05UPg0K
PEJSPjxGT05UIFNJWkU9Mj4mZ3Q7IG5vdC4gVGhlICZxdW90O2V4ZWN1dGUgaW1tZWRpYXRlJnF1
b3Q7LCBhcyB0aGUgcGVyc29uIHNwb2tlIG9mLCBzb3VuZHMgbGlrZSBpdCBzaG91bGQ8L0ZPTlQ+
DQo8QlI+PEZPTlQgU0laRT0yPiZndDsgd29yayBqdXN0IGZpbmUuIFRoZXJlIGFyZSBzdGlsbCBj
YXNlcyB3aGVyZSB0aGUgb2xkIERCTVNfU1FMIHN0dWZmIGlzPC9GT05UPg0KPEJSPjxGT05UIFNJ
WkU9Mj4mZ3Q7IHByZWZlcmFibGU7IGJ1dCwgY3JlYXRpbmcgYW5kIGRyb3BwaW5nIHNlcXVlbmNl
cyBzaG91bGQgYmUgYWJsZSB0byBiZSBkb25lPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj4mZ3Q7
IHdpdGggJnF1b3Q7ZXhlY3V0ZSBpbW1lZGlhdGUmcXVvdDsgd2l0aG91dCByZXNvcnRpbmcgdG8g
REJNU19TUUw6PC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj4mZ3Q7IDwvRk9OVD4NCjxCUj48Rk9O
VCBTSVpFPTI+Jmd0OyBTUUwmZ3Q7IGJlZ2luPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj4mZ3Q7
Jm5ic3A7Jm5ic3A7IDImbmJzcDsgZXhlY3V0ZSBpbW1lZGlhdGUgJ2NyZWF0ZSBzZXF1ZW5jZSB4
eHgnOzwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTI+Jmd0OyZuYnNwOyZuYnNwOyAzJm5ic3A7IGVu
ZDs8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yPiZndDsmbmJzcDsmbmJzcDsgNCZuYnNwOyAvPC9G
T05UPg0KPEJSPjxGT05UIFNJWkU9Mj4mZ3Q7IDwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTI+Jmd0
OyBQTC9TUUwgcHJvY2VkdXJlIHN1Y2Nlc3NmdWxseSBjb21wbGV0ZWQuPC9GT05UPg0KPEJSPjxG
T05UIFNJWkU9Mj4mZ3Q7IDwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTI+Jmd0OyBTUUwmZ3Q7IHNl
bGVjdCB4eHgubmV4dHZhbCBmcm9tIGR1YWw7PC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj4mZ3Q7
IDwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTI+Jmd0OyZuYnNwOyZuYnNwOyZuYnNwOyBORVhUVkFM
PC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj4mZ3Q7IC0tLS0tLS0tLS08L0ZPTlQ+DQo8QlI+PEZP
TlQgU0laRT0yPiZndDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsm
bmJzcDsmbmJzcDsgMTwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTI+Jmd0OyA8L0ZPTlQ+DQo8QlI+
PEZPTlQgU0laRT0yPiZndDsgU1FMJmd0OyBiZWdpbjwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTI+
Jmd0OyZuYnNwOyZuYnNwOyAyJm5ic3A7IGV4ZWN1dGUgaW1tZWRpYXRlICdkcm9wIHNlcXVlbmNl
IHh4eCc7PC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj4mZ3Q7Jm5ic3A7Jm5ic3A7IDMmbmJzcDsg
ZW5kOzwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTI+Jmd0OyZuYnNwOyZuYnNwOyA0Jm5ic3A7IC88
L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yPiZndDsgPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj4m
Z3Q7IFBML1NRTCBwcm9jZWR1cmUgc3VjY2Vzc2Z1bGx5IGNvbXBsZXRlZC48L0ZPTlQ+DQo8QlI+
PEZPTlQgU0laRT0yPiZndDsgPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj4mZ3Q7IFNRTCZndDsg
c2VsZWN0IHh4eC5uZXh0dmFsIGZyb20gZHVhbDs8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yPiZn
dDsgc2VsZWN0IHh4eC5uZXh0dmFsIGZyb20gZHVhbDwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTI+
Jmd0OyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyAqPC9GT05UPg0K
PEJSPjxGT05UIFNJWkU9Mj4mZ3Q7IEVSUk9SIGF0IGxpbmUgMTo8L0ZPTlQ+DQo8QlI+PEZPTlQg
U0laRT0yPiZndDsgT1JBLTAyMjg5OiBzZXF1ZW5jZSBkb2VzIG5vdCBleGlzdDwvRk9OVD4NCjxC
Uj48Rk9OVCBTSVpFPTI+Jmd0OyA8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yPiZndDsgU28sIHdo
YXQgdHlwZSBvZiBlcnJvcnMgYXJlIHlvdSBzZWVpbmc/IFdoZW4geW91IHVzZSB0aGUgZXhlY3V0
ZSBpbW1lZGlhdGU8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yPiZndDsgd2l0aCB0aGUgc2VxdWVu
Y2Ugc3R1ZmYgaW4tbGluZSwgeW91IHNheSBpdCBkb2Vzbid0IGNvbXBpbGUuIFdoZW4geW91IGFz
c2lnbjwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTI+Jmd0OyB0aGUgY29tbWFuZCB0byBhIHZhcmlh
YmxlLCB0aGVuLCByZWZlcmVuY2UgdGhlIHZhcmlhYmxlIGluIHlvdXIgZXhlY3V0ZTwvRk9OVD4N
CjxCUj48Rk9OVCBTSVpFPTI+Jmd0OyBpbW1kZWRpYXRlLCB5b3Ugc2F5IGl0IGNvbXBpbGVzLiBE
b2VzIGl0IHdvcmsgdGhlbj88L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yPiZndDsgPC9GT05UPg0K
PEJSPjxGT05UIFNJWkU9Mj4mZ3Q7IEkgYnJpbmcgdGhpcyB1cCBiZWNhdXNlIEkgY2FuIGRvIHdo
YXQgeW91IGFyZSB0cnlpbmcgZG8uIFRoaXMgaXMgb24gYW4gTlQ8L0ZPTlQ+DQo8QlI+PEZPTlQg
U0laRT0yPiZndDsgd29ya3N0YXRpb24gd2l0aCBTUDUuIEFuZCB1c2luZyB0aGUgbmV3ZXIgZHlu
YW1pYyBTUUwgYXBwcm9hY2ggb2YgZXhlY3V0ZTwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTI+Jmd0
OyBpbW1lZGlhdGUgbGlrZSB5b3UgZGlkLjwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTI+Jmd0OyA8
L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yPiZndDsgVGhlcmUgY291bGQgYmUgb3RoZXIgdGhpbmdz
IGluIHBsYXkgaGVyZSAocGVybWlzc2lvbnMgYW5kIHJvbGVzIHZlcnN1cyBhPC9GT05UPg0KPEJS
PjxGT05UIFNJWkU9Mj4mZ3Q7IGRpcmVjdCBwcml2IHRoaW5nLCBtYXliZSBidWdzKS4gSSBoYXZl
IG5vIGlkZWEuIEkgaGF2ZSBubyBwcm9ibGVtIGRvaW5nIHdoYXQ8L0ZPTlQ+DQo8QlI+PEZPTlQg
U0laRT0yPiZndDsgeW91IHdhbnQgdG8gZG8uPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj4mZ3Q7
IDwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTI+Jmd0OyBSZWdhcmRzLDwvRk9OVD4NCjxCUj48Rk9O
VCBTSVpFPTI+Jmd0OyA8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yPiZndDsgTGFycnkgRy4gRWxr
aW5zPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj4mZ3Q7IFRoZSBFbGtpbnMgT3JnYW5pemF0aW9u
IEluYy48L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yPiZndDsgZWxraW5zbEBmbGFzaC5uZXQ8L0ZP
TlQ+DQo8QlI+PEZPTlQgU0laRT0yPiZndDsgMjE0Ljk1NC4xNzgxPC9GT05UPg0KPEJSPjxGT05U
IFNJWkU9Mj4mZ3Q7IDwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTI+Jmd0OyAtLS0tLU9yaWdpbmFs
IE1lc3NhZ2UtLS0tLTwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTI+Jmd0OyBUdXJuZXI8L0ZPTlQ+
DQo8QlI+PEZPTlQgU0laRT0yPiZndDsgU2VudDogV2VkbmVzZGF5LCBKdW5lIDI4LCAyMDAwIDEw
OjI1IEFNPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj4mZ3Q7IFRvOiBNdWx0aXBsZSByZWNpcGll
bnRzIG9mIGxpc3QgT1JBQ0xFLUw8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yPiZndDsgPC9GT05U
Pg0KPEJSPjxGT05UIFNJWkU9Mj4mZ3Q7IDwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTI+Jmd0OyBT
aW5jZSB0aG9zZSBwYXJ0aWN1bGFyIHN0YXRlbWVudHMgYXJlIGNvbnNpZGVyZWQgRERMIHN0YXRl
bWVudHMsIHlvdSBuZWVkPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj4mZ3Q7IHRvIHVzZSB0aGUg
REJNU19TUUwgY29tbWFuZHMgdG8gZXhlY3V0ZSB0aGVtIHdpdGhpbiBhIHBsL3NxbCBwYWNrYWdl
LjwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTI+Jmd0OyA8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0y
PiZndDsgQ2hyaXN0aW5lIFR1cm5lcjwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTI+Jmd0OyBEYXRh
YmFzZSBBZG1pbmlzdHJhdG9yPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj4mZ3Q7IElQUy1TZW5k
ZXJvPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj4mZ3Q7IFNjb3R0c2RhbGUsIEFyaXpvbmE8L0ZP
TlQ+DQo8QlI+PEZPTlQgU0laRT0yPiZndDsgUGhvbmU6Jm5ic3A7ICg4MDApIDMyMS02ODk5IGV4
dC4gMzI4NjwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTI+Jmd0OyBGYXg6Jm5ic3A7Jm5ic3A7Jm5i
c3A7Jm5ic3A7Jm5ic3A7ICg0ODApIDk0Ni04MjI0PC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj4m
Z3Q7IEUtbWFpbDombmJzcDsgY2hyaXN0aW5lLnR1cm5lckBpcHMtc2VuZGVyby5jb208L0ZPTlQ+
DQo8QlI+PEZPTlQgU0laRT0yPiZndDsgPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj4mZ3Q7IDwv
Rk9OVD4NCjxCUj48Rk9OVCBTSVpFPTI+Jmd0OyA8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yPiZn
dDsgLS0tLS1PcmlnaW5hbCBNZXNzYWdlLS0tLS08L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yPiZn
dDsgRnJvbTogTWlrZSAmYW1wOyBNYXJ0aGEgW1NNVFA6bW1yb3NlQGhvbWUuY29tXTwvRk9OVD4N
CjxCUj48Rk9OVCBTSVpFPTI+Jmd0OyBTZW50OiBXZWRuZXNkYXksIEp1bmUgMjgsIDIwMDAgNzow
OSBBTTwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTI+Jmd0OyBUbzombmJzcDsmbmJzcDsgTXVsdGlw
bGUgcmVjaXBpZW50cyBvZiBsaXN0IE9SQUNMRS1MPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj4m
Z3Q7IFN1YmplY3Q6Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7IERyb3BwaW5nICZhbXA7
IHJlLUNyZWF0aW5nIFNlcXVlbmNlcyBpbiBQTC9TUUw8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0y
PiZndDsgPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj4mZ3Q7IDwvRk9OVD4NCjxCUj48Rk9OVCBT
SVpFPTI+Jmd0OyBIZWxsbyw8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yPiZndDsgPC9GT05UPg0K
PEJSPjxGT05UIFNJWkU9Mj4mZ3Q7IEkndmUgYmVlbiB1bmFibGUgdG8gZ2V0IHRoZSBmb2xsb3dp
bmcgY29tbWFuZHMgdG8gJ2NvbXBpbGUnIGluIGEgUEwvU1FMPC9GT05UPg0KPEJSPjxGT05UIFNJ
WkU9Mj4mZ3Q7IHBhY2thZ2UgYm9keSBpbiBPcmFjbGUgOC4xLjYgVmVyc2lvbiAyICg4aSB3aXRo
IE5UUyA0LjAgU1AgNmEpOjwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTI+Jmd0OyA8L0ZPTlQ+DQo8
QlI+PEZPTlQgU0laRT0yPiZndDsgRFJPUCBTRVFVRU5DRSBzZXF1ZW5jZV9uYW1lOzwvRk9OVD4N
CjxCUj48Rk9OVCBTSVpFPTI+Jmd0OyA8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yPiZndDsgQ1JF
QVRFIFNFUVVFTkNFIHNlcXVlbmNlX25hbWU7PC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj4mZ3Q7
IDwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTI+Jmd0OyBJIGdldCBlcnJvcnMgbGlrZSB0aGUgY29t
bWFuZHMgYXJlbid0IHJlY29nbml6ZWQuPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj4mZ3Q7IDwv
Rk9OVD4NCjxCUj48Rk9OVCBTSVpFPTI+Jmd0OyBXaGVuIEkgdHJ5IHRvIHVzZSBFWEVDVVRFIElN
TUVESUFURSAnRFJPUCBTRVFVRU5DRSBzZXF1ZW5jZV9uYW1lJzwvRk9OVD4NCjxCUj48Rk9OVCBT
SVpFPTI+Jmd0OyA8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yPiZndDsgSSBzdGlsbCBnZXQgY29t
cGlsZSBlcnJvcnMuPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj4mZ3Q7IDwvRk9OVD4NCjxCUj48
Rk9OVCBTSVpFPTI+Jmd0OyBJIGNhbiBjb21waWxlIHdoZW4gSSB1c2UgdG8gZm9sbG93aW5nOjwv
Rk9OVD4NCjxCUj48Rk9OVCBTSVpFPTI+Jmd0OyA8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yPiZn
dDsgVGVtcCBWQVJDSEFSMig2MCk7PC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj4mZ3Q7IDwvRk9O
VD4NCjxCUj48Rk9OVCBTSVpFPTI+Jmd0OyBUZW1wIDo9ICdEUk9QIFNFUVVFTkNFIHNlcXVlbmNl
X25hbWUnOzwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTI+Jmd0OyA8L0ZPTlQ+DQo8QlI+PEZPTlQg
U0laRT0yPiZndDsgRVhFQ1VURSBJTU1FRElBVEUgVGVtcDs8L0ZPTlQ+DQo8QlI+PEZPTlQgU0la
RT0yPiZndDsgPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj4mZ3Q7IEkgd291bGQgcmVhbGx5IGFw
cHJlY2lhdGUgc29tZSBoZWxwIGhlcmUhPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj4mZ3Q7IDwv
Rk9OVD4NCjxCUj48Rk9OVCBTSVpFPTI+Jmd0OyBNaWNoYWVsIFJvc2U8L0ZPTlQ+DQo8QlI+PEZP
TlQgU0laRT0yPiZndDsgbW1yb3NlQGhvbWUuY29tPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj4m
Z3Q7IDwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTI+Jmd0OyAtLSA8L0ZPTlQ+DQo8QlI+PEZPTlQg
U0laRT0yPiZndDsgQXV0aG9yOiBMYXJyeSBHLiBFbGtpbnM8L0ZPTlQ+DQo8QlI+PEZPTlQgU0la
RT0yPiZndDsmbmJzcDsmbmJzcDsgSU5FVDogZWxraW5zbEBmbGFzaC5uZXQ8L0ZPTlQ+DQo8QlI+
PEZPTlQgU0laRT0yPiZndDsgPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj4mZ3Q7IEZhdCBDaXR5
IE5ldHdvcmsgU2VydmljZXMmbmJzcDsmbmJzcDsmbmJzcDsgLS0gKDg1OCkgNTM4LTUwNTEmbmJz
cDsgRkFYOiAoODU4KSA1MzgtNTA1MTwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTI+Jmd0OyBTYW4g
RGllZ28sIENhbGlmb3JuaWEmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJz
cDsgLS0gUHVibGljIEludGVybmV0IGFjY2VzcyAvIE1haWxpbmcgTGlzdHM8L0ZPTlQ+DQo8QlI+
PEZPTlQgU0laRT0yPiZndDsgLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS08L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yPiZn
dDsgVG8gUkVNT1ZFIHlvdXJzZWxmIGZyb20gdGhpcyBtYWlsaW5nIGxpc3QsIHNlbmQgYW4gRS1N
YWlsIG1lc3NhZ2U8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yPiZndDsgdG86IExpc3RHdXJ1QGZh
dGNpdHkuY29tIChub3RlIEVYQUNUIHNwZWxsaW5nIG9mICdMaXN0R3VydScpIGFuZCBpbjwvRk9O
VD4NCjxCUj48Rk9OVCBTSVpFPTI+Jmd0OyB0aGUgbWVzc2FnZSBCT0RZLCBpbmNsdWRlIGEgbGlu
ZSBjb250YWluaW5nOiBVTlNVQiBPUkFDTEUtTDwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTI+Jmd0
OyAob3IgdGhlIG5hbWUgb2YgbWFpbGluZyBsaXN0IHlvdSB3YW50IHRvIGJlIHJlbW92ZWQgZnJv
bSkuJm5ic3A7IFlvdSBtYXk8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yPiZndDsgYWxzbyBzZW5k
IHRoZSBIRUxQIGNvbW1hbmQgZm9yIG90aGVyIGluZm9ybWF0aW9uIChsaWtlIHN1YnNjcmliaW5n
KS48L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yPiZndDsgPC9GT05UPg0KPC9QPg0KPEJSPg0KDQo8
UD48Rk9OVCBTSVpFPTI+SmFyZWQgU3RpbGw8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yPkNlcnRp
ZmllZCBPcmFjbGUgREJBIGFuZCBQYXJ0IFRpbWUgUGVybCBFdmFuZ2VsaXN0Jm5ic3A7IDstKTwv
Rk9OVD4NCjxCUj48Rk9OVCBTSVpFPTI+UmVnZW5jZSBCbHVlQ3Jvc3MgQmx1ZVNoaWVsZCBvZiBP
cmVnb248L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yPmprc3RpbGxAYmNic28uY29tIC0gV29yayAt
IHByZWZlcnJlZCBhZGRyZXNzPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj5qa3N0aWxsQHRlbGVw
b3J0LmNvbSAtIHByaXZhdGU8L0ZPTlQ+DQo8L1A+DQo8QlI+DQoNCjxQPjxGT05UIFNJWkU9Mj4t
LSA8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yPkF1dGhvcjogSmFyZWQgU3RpbGw8L0ZPTlQ+DQo8
QlI+PEZPTlQgU0laRT0yPiZuYnNwOyBJTkVUOiBqa3N0aWxsQGJjYnNvLmNvbTwvRk9OVD4NCjwv
UD4NCg0KPFA+PEZPTlQgU0laRT0yPkZhdCBDaXR5IE5ldHdvcmsgU2VydmljZXMmbmJzcDsmbmJz
cDsmbmJzcDsgLS0gKDg1OCkgNTM4LTUwNTEmbmJzcDsgRkFYOiAoODU4KSA1MzgtNTA1MTwvRk9O
VD4NCjxCUj48Rk9OVCBTSVpFPTI+U2FuIERpZWdvLCBDYWxpZm9ybmlhJm5ic3A7Jm5ic3A7Jm5i
c3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7IC0tIFB1YmxpYyBJbnRlcm5ldCBhY2Nlc3MgLyBN
YWlsaW5nIExpc3RzPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9Mj4tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLTwvRk9OVD4N
CjxCUj48Rk9OVCBTSVpFPTI+VG8gUkVNT1ZFIHlvdXJzZWxmIGZyb20gdGhpcyBtYWlsaW5nIGxp
c3QsIHNlbmQgYW4gRS1NYWlsIG1lc3NhZ2U8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yPnRvOiBM
aXN0R3VydUBmYXRjaXR5LmNvbSAobm90ZSBFWEFDVCBzcGVsbGluZyBvZiAnTGlzdEd1cnUnKSBh
bmQgaW48L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yPnRoZSBtZXNzYWdlIEJPRFksIGluY2x1ZGUg