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
