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 (
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->{AutoCommi
That would work fine, just that escape for the single quote is not needed.
Ilya
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 8/16/01 4:51 AM
Subject: Re: Problems with INSERT
OK.
> > better $sth = ( "INSERT INTO bearbeiter (funktionID, redakteu
OK.
> > better $sth = ( "INSERT INTO bearbeiter (funktionID, redakteurID) VALUES
> > ('$funktionID', '$redakteurID')" );
> >$dbh->do($sth) or die "Copy mistake ($sth)";
>
> And that will break when presented with a $funktionID or $redakturID value
> containing quotes, etc, so in general,
Andreas-Schmitz wrote:
> my $dbh = DBI->connect($dsn, $user, $passwort,{RaiseError => 1});
>
>
> > $dbh->do("INSERT INTO bearbeiter (funktionID, redakteurID) ".
> > "VALUES ('$funktionID', '$redakteurID')");
>
> better $sth = ( "INSERT INTO bearbeiter (funktionID, redakteurID) VALUES
>
my $dbh = DBI->connect($dsn, $user, $passwort,{RaiseError => 1});
> $dbh->do("INSERT INTO bearbeiter (funktionID, redakteurID) ".
> "VALUES ('$funktionID', '$redakteurID')");
better $sth = ( "INSERT INTO bearbeiter (funktionID, redakteurID) VALUES
('$funktionID', '$redakteurID')" );
See my comments below...
Marcus Willemsen [[EMAIL PROTECTED]] wrote:
> Hi all,
>
> I am having troubles with the script below. (I hope nobody minds that the
> names of the variables and params are in German)
>
> The script reads data coming from a form and inserts it inot the
> appropriate ta
Hi all,
I am having troubles with the script below. (I hope nobody minds that the
names of the variables and params are in German)
The script reads data coming from a form and inserts it inot the
appropriate tables. Well it works for almost all values except for
$ueberschrift and $text. The f