There is no DBD::Oracle equivalent for retrieving the value of
insert_id. You must create a sequence within oracle, then retrieve its
value and assign it to a variable within your script. You can then use
that value when you execute your insert and later in your script.
Jim
At 12:14 PM 6/8/01 -0700, Gregory wrote:
>I'm migrating from MySQL to Oracle. When I'm executing "INSERT... " with
>DBD::mysql I could get the id of inserted row with DBH->{mysql_insertid}.
>Is there any way to do the same thing with Oracle (DBD::Oracle)?
>
>Thanks. Grisha.
#!/usr/local/bin/perl
push@J,[($")x70]for 0..20;sub p{$J[$q][$p]=$_;print"\e[H\e[J";print@$_,$/for@J
;$J[$q][$p]=$"}sub f{sprintf"%.f",pop}for('Just another Perl hacker.'=~/./g){$
t=/ /and$J[20][$X++]=$_,next;{$x=70+$t*($X-70)*.8;$y=20-63.25*$t+50*$t**2;last
if$x<$X;$p=f$x;p$q=f$y;$t+=.1;select$,,$,,$,,.1;redo}$J[20][$X++]=$_}p
