RAPIDMINER 9.7 BETA ANNOUNCEMENT

The beta program for the RapidMiner 9.7 release is now available. Lots of amazing new improvements including true version control!

CLICK HERE TO DOWNLOAD

"Execute stored procedure with Read Database operator"

EMDuellEMDuell Member Posts: 21 Contributor I
edited June 2019 in Help
Hello,

I'm attempting to execute a stored procedure with the Read Database operator and I receive an error, saying "executeQuery only accepts the SELECT statement".

Is there a special technique I need to use to pass parameters to a stored procedure so that I can read the results into an example set?  I thought about the the Execute SQL operator, but that won't work.

Thanks for the help..code below.

-Eric

---
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<process version="5.3.015">
 <context>
   <input/>
   <output/>
   <macros/>
 </context>
 <operator activated="true" class="process" compatibility="5.3.015" expanded="true" name="Process">
   <process expanded="true">
     <operator activated="true" class="read_database" compatibility="5.3.015" expanded="true" height="60" name="Read Database" width="90" x="45" y="19">
       <parameter key="connection" value="TestQuery"/>
       <parameter key="query" value="EXEC GetRemainingRequests @Resource=Trends"/&gt;
       <enumeration key="parameters"/>
     </operator>
     <connect from_op="Read Database" from_port="output" to_port="result 1"/>
     <portSpacing port="source_input 1" spacing="0"/>
     <portSpacing port="sink_result 1" spacing="0"/>
     <portSpacing port="sink_result 2" spacing="0"/>
   </process>
 </operator>
</process>


Tagged:

Answers

  • BalazsBaranyBalazsBarany Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert Posts: 441   Unicorn
    Does your function return a table structure? If it does, try wrapping it in a SELECT query:

    SELECT *
    FROM (
       EXEC GetRemainingRequests @Resource=Trends
    )

    There is also an Execute SQL operator for calling arbitrary functions but it doesn't return an example set.
Sign In or Register to comment.