Integration

Hi there,

I am trying to figure out the best way to call a complex Oracle Stored Procedure using Spring and possibly toplink.

Have implemented a couple of simple stored procedures using the Spring StoredProcedure class.

However the challenge now is calling the stored procedure with %ROWTYPE and Table Type parameters in the Stored Procedure Signatures.

PROCEDURE release_batch (
      p_api_version                IN              NUMBER
            := gme_api_pub.api_version,
      p_validation_level           IN              NUMBER
            := gme_api_pub.max_errors,
      p_init_msg_list              IN              BOOLEAN := FALSE ,
      p_commit                     IN              BOOLEAN := FALSE ,
      x_message_count          OUT NOCOPY      NUMBER,
      x_message_list              OUT NOCOPY      VARCHAR2,
      x_return_status             OUT NOCOPY      VARCHAR2,
      p_batch_header             IN              gme_batch_header%ROWTYPE,
      x_batch_header             OUT NOCOPY      gme_batch_header%ROWTYPE,
      p_ignore_shortages         IN              BOOLEAN,
      p_consume_avail_plain_item   IN              BOOLEAN DEFAULT FALSE ,
      x_unallocated_material     OUT NOCOPY      gme_api_pub.unallocated_materials_tab,
      p_ignore_unalloc             IN              BOOLEAN DEFAULT FALSE