Question Renato Araujo · Mar 8, 2022 Is it possible to receive Oracle Object Type as an output from stored procedure? (java.sql.Types STRUCT) Hello everyone! I am writing a SQL CALL (using JDBC) to a stored procedure that outputs a structured object (Oracle Object). However, the adapter method is not accepting the corresponding JDBC Data Type STRUCT for the output parameter, returning the following error: #Interoperability #JDBC #SQL #InterSystems IRIS 0 0 0 450
Question Renato Araujo · Feb 20, 2022 How to display %Status in readable form? Hi all, I am trying to use a %Status property on some of my Response classes. If the execution of a service goes wrong, I set the %Status property on Response with the value $$$ERROR($$$GeneralError, "pre-defined error message"). When I check the visual trace for this message and look for the %Status (property "status_code" on the image), it is displayed like this: If I select to display the Body of the Response, I get the 'readable' form of %Status: #ObjectScript #Visualization #InterSystems IRIS 0 1 0 301