[prev in list] [next in list] [prev in thread] [next in thread] 

List:       dbi-dev
Subject:    How to use sequence table.
From:       "K.Takami" <takami () mikigw2 ! paris-miki ! co ! jp>
Date:       1996-11-24 11:45:24
[Download RAW message or body]

    *** From dbi-users -- To unsubscribe, see the end of this message. ***

  Hello perl&oracle gurus.

I want to use the following sql sentence:
    " insert into table values ( no, :1, :2 ) "
which has two substitution variables.
The first field gets value from sequence table.
i.e. I'd like to use "sequence_table.nextval" instead of no.

   $lda = ora_login( $ora_sid, $userid, $passwd );
   $s = 'insert into table values (sequence_table.nextval,:1,:2)';
   $csr = &ora_open($lda, $s, 10);
   
   &ora_bind( $csr, 'aaa', 'bbb' );
   $ora_commit($lda);

   &ora_close($csr);
   &ora_logoff($lda);

is it right ?

I don't know how to use sequence table.

Please tell me how to use it. Thanks in advance.

--------------------
Takami Keiichi
(takami@mikigw2.paris-miki.co.jp)


------------------------------------------------------------------------------
To unsubscribe from this list, please visit http://www.fugue.com/dbi.
If you are without web access, or if you are having trouble with the web page,
please send mail to dbi-request@fugue.com.   Please try to use the web
page first - it will take a long time for your request to be processed by hand.
------------------------------------------------------------------------------

[prev in list] [next in list] [prev in thread] [next in thread]