Ajax , Call Procedure (oracle) , xml

[Patric]

hello
The oracle procedure must be called using Ajax.

var argData =
     {
         …..
     };
     $.ajax({ method: “POST”,
               url : ……/api/abc.xml,
             })
             .done( function( data )
             {
                 var value = JSON.parse(data);
             });

abc.xml uses the structure below.

<select id="getUserList" resultMap="UserVO">
    <![CDATA[
    select * from user where id > @id
    ]]>
</select>

I need to modify the above code structure to call the oracle procedure.
How should I call the procedure?

Can I just change the xml code below?

<select id="getUserList" resultMap="UserVO">

    <![CDATA[

    EXECUTE sp_procedure @id

    ]]>

</select>

 

[Patric]

ajax({ method: "POST",
url: ...xml
dara: para,
async:false,
dataType: :"JSON"
}).done(function (data) {

 

[VBService]

Did you tried in that way:

for

abc.xml (PL/SQL syntax)

<select id="callProcedure" statementType="CALLABLE">
  <![CDATA[
    {call sp_procedure(#{id})}
  ]]>
</select>

var argData = {
    id: 123 // Replace with the actual value for 'id' parameter
};

$.ajax({
    method: "POST",
    url: ".../api/abc.xml", // Replace with the actual URL
    data: JSON.stringify(argData), // Send the parameter as JSON data
    contentType: "application/json", // Set the content type to JSON
})
.done(function (data) {
    // Handle the response data if needed
})
.fail(function (error) {
    // Handle any errors
});

 

[Patric]

Please Help Me

C# DataTable | C, C++ and C#

Hello. The conversion must be done as shown in the picture below. How can I convert DataTable efficiently? I can't program. I want to return DataTable Type. I programmed the code below. I don't like the code below. DataRow[] rowKPS = originalDt.Select("subject = 'KPS'"); DataRow[] rowDPA...

www.thecodingforums.com