Re: selecting into unix variable

In article <1995Oct28.082748.2138_at_pyra.co.uk>

           markb_at_pyramid.com "Mark Bluemel" writes:

>
> Tony Jambu (aaj_at_phantom.telecom.com.au) wrote:
> : In article <1995Oct16.183321.24297_at_lamont.ldgo.columbia.edu>,
> : anarayan_at_sctcorp.com (Ananta Narayanan) writes:
> : > Ellen Storz <ellen_at_.pacific.net> wrote:
 

> : > Write this into a script
> : > file get_sequence.sql
> : >
> : > set verify off
> : > set feedback off
> : >
> : > select seq.nextval
> : > from dual
> : > /
> : > exit sql.sqlcode
> : >
> : > Just write
> : >
> : > UNIX_VAR=`sqlplus -s <usercode>/<password> _at_get_sequence.sql`
 

> : Be warn that the maximum value you can have is 256.
>
> Could you expand on this statement - what limits you to 256 ?
>
> Certainly ORACLE sequence generators don't.
>
> --
> Mark Bluemel Unix/Oracle Trainer and Consultant
> My opinions are my own, but I'll share them
> All solutions to problems are offered "as is"
> and without warranty - you have been warned :-)
>

There are Unix limits to the size of variables - and they differ between flavours.

Andy

-- 
Andy Hardy (Internet: aph_at_ahardy.demon.co.uk, CIS: 100015,2603)
PGP key available on request
===============================================================
Don't look now but the man in the moon is laughing at you.