DBI bind_param_inout question

[email protected] (Bruce Johnson)
Newsgroups perl.dbi.users
Message-ID <[email protected]>
The syntax is $csr->bind_param_inout(':var',\$perlvar,$maxlength)

My question is what is $maxlength in relation to the database.

If my statement is returning a number (a sequence value) how big do I  
need it to be?

My sql is

insert into reservedroom (id, requesttime, roomid, day, purpose,  
reserver,email, affil,requesterpid)  
values 
(reservedid 
.nextval,sysdate,:roomid,:theday,:purp,:reserve,:remail,:affil,:pid)  
returning id into :newrez"

and the bind_param_inout parameter is :newrez.

This value will never get higher than 999,999,999 (the database has  
been running for 6 or 7 years now and currval = 127,616).

-- 
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group

Institutions do not have opinions, merely customs
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.