Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Can someone with access to 8ir3 test this for me please?

Re: Can someone with access to 8ir3 test this for me please?

From: Jeff <jeff_at_work.com>
Date: Thu, 19 Feb 2004 13:39:49 GMT
Message-ID: <c12eb4$opm$1@cronkite.cc.uga.edu>


Okay, teach me. Why would you expect that (:moah) to work?

In article <73e20c6c.0402190308.16e9171e_at_posting.google.com>, wizofoz2k_at_yahoo.com.au (Noons) wrote:
>Here is what clunks in 9ir2, reduced form:
>
>SQL> select * from user_sequences;
>Press Return to continue...
>
>SEQUENCE_NAME MIN_VALUE MAX_VALUE INCREMENT_BY C O
> CACHE_SIZE
> LAST_NUMBER
>------------------------------ ---------- ---------- ------------ - -
> ----------
> -----------
>MY_SEQ 1 1.0000E+27 1 N N
> 20
> 1
>
>Elapsed: 00:00:00.05
>SQL> set echo on
>SQL> start zot
>SQL> declare
> 2 my_int pls_integer;
> 3 my_str varchar2(2000);
> 4 begin
> 5 my_str:= 'alter sequence my_seq minvalue :moah';
> 6 my_int:= 10;
> 7 execute immediate my_str using my_int;
> 8 end;
> 9 /
>declare
>*
>ERROR at line 1:
>ORA-01722: invalid number
>ORA-06512: at line 7
>
>
>Elapsed: 00:00:00.00
>SQL>
>
>I need to know if this also happened in 8ir3?
>Many TIA for any help.
>Cheers
>Nuno Souto
>wizofoz2k_at_yahoo.com.au.nospam
Received on Thu Feb 19 2004 - 07:39:49 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US