Try this

$csr->bind_param_inout(":INSTIDNO",\$newinstid,38);

38 is an  SQL_DECIMAL  which is what you want to return

cheers
John S

>
> This is with oracle 11. Using Oracle DBD 1.17 (I know it's ancient,
> but this used to work)
>
> broken part:
>
>       $sq_newinst = "insert into institution (instid, inst_name,
> $insttype) values (institution_seq.nextval, '$newinstname', 'Y')
> returning instid into :INSTIDNO";
>
>       $lda->{AutoCommit} = 1;
>       $csr = $lda->prepare($sq_newinst);
>               if ( $ora_errstr ) {
>               print &PrintHeader;
>               print "$ora_errstr\n";
>               print "$sq_newinst\n";
>               exit;
>               }
>       $newinstid=0;
>       $csr->bind_param_inout(":INSTIDNO",\$newinstid,10);
>       $csr->execute();
>
>
> If I run the above code, the insert happens, but nothing but 'instid'
> is inserted, which is appropriately returned. My script ends with
> "Institution $inst_name added instid = $newinstid"
>
> And both the name and new ID number are correctly returned. But the
> values for inst_name and $insttype (which is one of three different
> institution type columns) are not insterted, only the
> institution_seq.nextval.
>
> This is the sql code that is passed to the database:
>
> insert into institution (instid, inst_name, is_zoo) values
> (institution_seq.nextval, 'Roadrunner Zoo of The Canyons', 'Y')
> returning instid into :INSTIDNO
>
> So I know it's going out.
>
> If I omit the 'returning instid into :INSTIDNO' part of the clause,
> the insert happens correctly.
>
> --
> Bruce Johnson
> University of Arizona
> College of Pharmacy
> Information Technology Group
>
> Institutions do not have opinions, merely customs
>
>
>


Reply via email to