Skip to Content
avatar image
Former Member

Sequence on Oracle Database column

Hi All,

In my scenario I have to insert data/records into a Oracle Database.The Database table has primary key with Sequence(sequence will generate next unique value for the new record to be inserted). So how can I insert the records into that table. I have created JDBC receiver message type for that particular table.

Please let me know the possible ways.

Thanks

Praveen Kumar

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Jun 04, 2007 at 11:13 AM

    Using Stored Proecdure is one option.Write a stored procedure that takes the rest of the column values as inputs and then uses the sequencne plus these values to insert data into the datbase.

    Can you provide an example of how the insert query with the Call to the Sequence looks so that a standard insert option can also be looked into?

    Regards

    Bhavesh

    Add comment
    10|10000 characters needed characters exceeded