tambde
asked on
How to update long field in oracle 7.3?
Hi,
I am writing a program which needs the program to update long field in the table.
I am using oracle 7.3 on solaris 2.6 and dbi module to connect to the oracle data base from the perl program.
when my input field is very small then i can update Long field properly but when my input variable grows to 4000 bytes or more it just aborts (doesn't update the long field).
I tried this on oracle 8 on windows NT 4.0 Then it works perfectly but does not work on the oracle 7.3 on solaris 2.6.
I am writing a program which needs the program to update long field in the table.
I am using oracle 7.3 on solaris 2.6 and dbi module to connect to the oracle data base from the perl program.
when my input field is very small then i can update Long field properly but when my input variable grows to 4000 bytes or more it just aborts (doesn't update the long field).
I tried this on oracle 8 on windows NT 4.0 Then it works perfectly but does not work on the oracle 7.3 on solaris 2.6.
I had the same problem, and I had to give up on perl and use a procedure using PL/SQL when I could guarantee that the long field was under 2 megs and I had to use the Pro C compiler when the long field could be over 2 Megs.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
oops... typo.
change:
($sql, $file_ref) = @_;
to:
($sql, $long_string) = @_;
change:
($sql, $file_ref) = @_;
to:
($sql, $long_string) = @_;
ASKER
$sql="update publication set
due_date='2000-1-22|2000-1
where pub_name='toi di1'";
$ab = $dbh->prepare($sql);
my $rc = $ab->bind_param(1, $temp_due_date, 24);
$rc = $ab->execute;
$rc = $dbh->commit;
I used above code but still it doesn't work.
due_date='2000-1-22|2000-1
where pub_name='toi di1'";
$ab = $dbh->prepare($sql);
my $rc = $ab->bind_param(1, $temp_due_date, 24);
$rc = $ab->execute;
$rc = $dbh->commit;
I used above code but still it doesn't work.
ASKER
$sql="update publication set
due_date='2000-1-22|2000-1
where pub_name='toi di1'";
$ab = $dbh->prepare($sql);
my $rc = $ab->bind_param(1, $temp_due_date, 24);
$rc = $ab->execute;
$rc = $dbh->commit;
I used above code but still it doesn't work.
Please help.
due_date='2000-1-22|2000-1
where pub_name='toi di1'";
$ab = $dbh->prepare($sql);
my $rc = $ab->bind_param(1, $temp_due_date, 24);
$rc = $ab->execute;
$rc = $dbh->commit;
I used above code but still it doesn't work.
Please help.
# the code works.
$sql =qq!update production set due_date=:1 where pub_name='toi di1'!;
# put all those pipe delimited dates in $long_string
insert_long($sql,\$long_st
__END__
looks like you need a better design for your data. you should have a seperate table for all of those dates. you shouldn't have to have pipe delimited data... this is the reason for a database.
$sql =qq!update production set due_date=:1 where pub_name='toi di1'!;
# put all those pipe delimited dates in $long_string
insert_long($sql,\$long_st
__END__
looks like you need a better design for your data. you should have a seperate table for all of those dates. you shouldn't have to have pipe delimited data... this is the reason for a database.