2 Replies Latest reply on Oct 7, 2004 3:30 AM by 423876

    Using Boolean in Istudio

    423876
      Hi,

      One of my integration requirement needs to call an oracle stored procedure, which returns a Boolean as status, using DB adapter on a request/response model. Could someone help me to model this in istudio. Istudio is not giving Boolean datatype. How can I achive this

      Thanks in anticipation
        • 1. Re: Using Boolean in Istudio
          428365

          Steps

          1. Create a Subscribe event (for the DB application, assuming you have already created the DB application)
          2. In the Wizard, import from Database, click on Procedures and import the appropriate procedure.

          If the boolean is an out variable and is not showing up in iStudio, send me the PL/SQL signature on this forum.

          ------------
          Anshu Sharma
          OracleAS Integration
          Oracle Corp.
          • 2. Re: Using Boolean in Istudio
            423876
            I have created an implemented procedure and imported the the stored procedure defenition to Istudio. Bollean is an OUT parameter. Istudio recognises this as a PL/SQL Type data type. But while saving the definition, it shows some error.